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 “balancer” with Change Limit: [1] [2] [3]

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

129 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
balancer124660(None) 
balance11510261balance_
balanced1356511balanced
balancers1345061balancers
balances1279971balances
bilander1136672bilander
blancher15338632b_lancher
blander103715162b_lander
blanker134612022b_lanker
glancer103710072_glancer
lancer84319972__lancer
valance1269252valance_
valanced1475462valanced
valances1398762valances
advancer1443483advancer
alane56135613_alan_e_
aliner65621983_alin_er
almner85710723_almn_er
balancing1435783balancing
balases93815433bala_ses
balder95318863bal__der
baler75635273bal___er
balker124519163bal__ker
balkier134111983bal_kier
balladeer1243023balladeer
ballaster1145973ballaster
baller83825203bal__ler
balloter1078893balloter
ballsier1036523ballsier
balmier113811513bal_mier
baloney1237483balon_ey
baluster1037053baluster
bander93928223b__ander
banger94423633b__anger
banker124222733b__anker
banner84421503b__anner
banter84825333b__anter
barnier93213673ba_rnier
bayadeer1442203bayadeer
belaced124112153bela_ced
belayer12339503bela_yer
bilanders1235963bilanders
bilayer12347803bila_yer
blabber10418923b_labber
blacker154513513b_lacker
bladder11429153b_ladder
blader93618583b_la_der
blamer104417143b_la_mer
blanch133410853b_lanc_h
blanched16308603b_lanched
blanchers16307433b_lanchers
blanches153311603b_lanches
blanked144011223b_lanked
blanket134313093b_lanket
blaster94017303b_laster
blather125314203b_lather
blatter94415653b_latter
blazer174414023b_la_zer
blencher15308393b_lencher
blender104613843b_lender
blinder103912983b_linder
blinker134110213b_linker
blonder104011943b_londer
blunder103813153b_lunder
blunger104112013b_lunger
blunter94512033b_lunter
bouncer113811333b_ouncer
bracer104620583b_ra_cer
brander103915823b_rander
branner94212373b_ranner
byliner1235723bylin_er
calender1138273calender
cancer104220923__cancer
chancer144215633_chancer
clanger104113493_clanger
colander1139033colander
dancer94817613__dancer
enhancer1346683enhancer
flanger113412623_flanger
flanker143911293_flanker
glance94312313_glance_
glanced11439233_glanced
glancers11408003_glancers
glances104113143_glances
imbalance1543923imbalance_
imbalanced1752483imbalanced
imbalances1643673imbalances
inlander937223inlander
islander946103islander
japanner1743013japanner
lacer75833753__la_cer
lance75126723__lance_
lanced93717723__lanced
lancers93616643__lancers
lances84824103__lances
lancet84223573__lancet
lander74028483__lander
lanker104123003__lanker
lanner64920603__lanner
malanders1237023malanders
malinger11116533malinger
palace104516913pala_ce_
palaced124110773pala_ced
palaces114216453pala_ces
palaver1238753pala_ver
parlance1248723parlance_
parlances1348953parlances
phalanger1554113phalanger
placer105117743_pla_cer
planer84122653_plan_er
planner93511623_planner
planter94017803_planter
prancer113613383_prancer
rebalance1345763rebalance_
rebalanced1543583rebalanced
rebalances1445253rebalances
romancer1247293romancer
silencer1036293silencer
slander84015443_slander
solacer93011103sola_cer
solander948123solander
unbalance1344013unbalance_
unbalanced1542943unbalanced
unbalances1443513unbalances
uplander1145533uplander
valence1268773valence_
valences1388513valences
valiance1397383valiance_
valiances1487203valiances

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621296.86021306.4
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.34624324.9
 
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.