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 “balancing” 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.

105 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
balancing143578(None) 
valancing1544741valancing
blanching17297092b_lanching
blanking154411932b_lanking
glancing1247062_glancing
lancing103314122__lancing
rebalancing1642372rebalancing
unbalancing1651702unbalancing
ablating11312003abla_ting
advancing1643063advancing
alanin6317273_alan_in_
alanine7316863_alan_ine
alanins7315803_alan_ins
alarming1138583_alarming
alining81917043_alin_ing
avalanching2051583avalanching
baaing94916163ba_a__ing
balance11510263balanc__e
balanced1356513balanc_ed
balancer1246603balanc_er
balancers1345063balancers
balances1279973balanc_es
balding114015063bal__ding
baling94829693bal___ing
balkanizing2754323balkanizing
balking143717353bal__king
ballasting1345303ballasting
balling104424763bal__ling
balloting1238393balloting
balsaming1445123balsaming
banding114921413b__anding
banging114019863b__anging
baning95127833b__an_ing
banking144621353b__anking
banning103818233b__anning
barning104320353ba_rn_ing
beaning103820683b_ean_ing
bechancing2044443bechancing
beduncing1543913beduncing
beladying1634763beladying
belauding1335463belauding
belaying143110603bela_ying
belonging1335913belonging
blabbing12266723b_labbing
blacking174213603b_lacking
blading113615363b_la_ding
blagging13319173b_lagging
blaming123515693b_la_ming
blaring104317113b_la_ring
blasting114013433b_lasting
blatting114111653b_latting
blawing134012753b_la_wing
blazing193612393b_la_zing
blenching17276503b_lenching
blending12249963b_lending
blinding123210163b_linding
blinking153510623b_linking
blunging12328413b_lunging
blunting11319843b_lunting
bouncing13318773b_ouncing
bracing123817613b_ra_cing
branching17289263b_ranching
branding122513683b_randing
branning112911093b_ranning
bylining1446013bylin_ing
cadencing1544963cadencing
chancing162810283_chancing
clanging124012123_clanging
clanking154313063_clanking
dancing113611563__dancing
enhancing1545823enhancing
enlacing1148773enla_cing
financing1544073financing
flanging132710583_flanging
flanking164211083_flanking
galantine1047333galantine
gallanting1245353gallanting
garlanding1344433garlanding
inlacing1158373inla_cing
islanding1135623islanding
japanning1943383japanning
jauncing18314783ja_uncing
lacing94626233__la_cing
landing92819323__landing
misbalancing1951683misbalancing
outbalancing1751643outbalancing
penancing1436343penancing
placing123815283_pla_cing
planing103418253_plan_ing
planking153513013_planking
planning113610223_planning
planting113515383_planting
prancing132612163_prancing
relacing112516043rela_cing
relanding112110923relanding
romancing1446043romancing
salaaming1265363salaaming
salarying1336073salarying
silencing1245053silencing
slanging103413433_slanging
slanting94115093_slanting
solacing11310133sola_cing
talcing103111633tal__cing
trancing112812023_trancing
unlacing1148653unla_cing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411057.25020502.2
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.73223110.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.