Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “fleers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
fleers9601579(None) 
fleer86020771fleer_
flees85828751flee_s
fleets96915061fleets
fliers94417191fliers
flyers125712801flyers
freers94717301freers
leers54828981_leers
alders74218422alders
alters64924222alters
ameers84015572ameers
beers75628392_beers
blears85116452blears
bleeds95211592bleeds
bleeps10499102bleeps
cheers114518912cheers
clears84116562clears
cleeks125010542cleeks
deers64930522_deers
elders74817302elders
elvers93814982elvers
emeers83314182emeers
facers115519442facers
faders105117462faders
fakeers14446672fakeers
fakers134219532fakers
fallers103917992fallers
falters103916472falters
farers95924052farers
fears84829392f_ears
feebs106112682f_eebs
feeders113712862feeders
feeds94921142f_eeds
feelers103814742feelers
feels85223042f_eels
fees76450602f_ee_s
fellers104117542fellers
feres86038182f_eres
fevers125414892fevers
fibers114717522fibers
fifers125414922fifers
filers94623722filers
fillers104320212fillers
filmers124211292filmers
filters103816552filters
firers94922682firers
fivers124420922fivers
fixers165112982fixers
flairs95711912flairs
flakers143613272flakers
flamers124616362flamers
flares94521702flares
flayers133912032flayers
fleams115011942fleams
fleas86423662fl_eas
flecks154310802flecks
flee76238792flee__
fleece11369902fleece
fleecers13325932fleecers
fleeces12399642fleeces
fleech14367342fleech
fleecy14266482fleecy
fleered11309502fleered
fleet85932332flee_t
flensers1135462flensers
fleshers14339442fleshers
fleury12417352fleury
flews115316442fl_ews
flexes164512952flexes
flexors1734772flexors
fleys117015602fl_eys
flier86023402flier_
flies85630712flie_s
flirs85518932fl_irs
floes85528142floe_s
floors94112352floors
flours94414052flours
flowers133413172flowers
flues84626922flue_s
fluors94311372fluors
fluters103713682fluters
flyer114916252flyer_
folders113514392folders
foyers125413132foyers
freer86021242freer_
frees86131392free_s
freres94716172freres
friers94718932friers
fryers125710972fryers
fuelers103912392fuelers
fullers103817372fullers
fumers113613382fumers
gleeds84711622gleeds
gleeks11489672gleeks
glees65027592glee_s
gleets75315052gleets
gluers75011152gluers
jeers124818132_jeers
lears55938732_lears
leeks95318892_leeks
leer46239352_leer_
leery85919132_leery
lees45455882_lee_s
leets54927122_leets
legers74518312_legers
lehrs86111132_lehrs
lepers84817322_lepers
levers94621322_levers
liers55130402_liers
peers75130272_peers
pliers84715152pliers
plyers114912982plyers
queers153510772queers
seers55136382_seers
sheers94322402sheers
sleeks104512462sleeks
sleeps83913322sleeps
sleets64318872sleets
sneers64016172sneers
speers85019952speers
steers63820982steers
ulcers839382ulcers
veers84521362_veers

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.343520965.0
2DLD Change Limit825511232.36034979.2
3Display Results1231230.0304100.0
 (SQL Overall)1786911232.73365382.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.