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

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

119 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
rebalancing164237(None) 
balancing1435782__balancing
unbalancing1651702unbalancing
freelancing1742243fre_elancing
misbalancing1951683misbalancing
outbalancing1751643outbalancing
overbalancing2151983overbalancing
rebalance1345763rebalanc__e
rebalanced1543583rebalanc_ed
rebalances1445253rebalanc_es
reblending1455813reb_lending
rebranching1943383reb_ranching
refinancing1742833refinancing
relacing112516043re__la_cing
relanding112110923re__landing
replacing142210163re_pla_cing
replanning1345313re_planning
replanting1338513re_planting
valancing1544743__valancing
avalanching2051584_avalanching
bechancing2044444be_chancing
blanching17297094__b_lanching
blanking154411934__b_lanking
deplaning1338054de_plan_ing
emplacing1645484_empla_cing
emplaning1446534_emplan_ing
enhancing1545824_e_nhancing
enlacing1148774_e_nla_cing
enplaning1246804_enplan_ing
entrancing1346784_entrancing
explanting2045224_explanting
glancing1247064___glancing
lancing103314124____lancing
necklacing1942814neckla_cing
penancing1436344pe__nancing
prefinancing2051944prefinancing
preplacing1746004pre_pla_cing
preplanning1643694pre_planning
preplanting1645924pre_planting
rataplanning1561004rataplanning
readapting1445154re_adapting
realigning1245934re_aligning
realising10313174re_al_ising
realizing19313814re_al_izing
realtering1139474re_altering
rearranging1343784rearranging
reasoning10310204re_ason_ing
reavailing1444874re_availing
reawaking17216074re_awa_king
rebaiting12311644reb__aiting
rebaptizing2543714rebaptizing
rebating112418344reb__a_ting
rebeginning1541984rebeginning
rebelling122111164rebel__ling
rebilling12228834rebil__ling
rebinding13249484reb__inding
reblooming1543424reb_looming
reboarding1445674reb_oarding
rebounding1435304reb_ounding
recalling122211904recal__ling
recaning111416694re__can_ing
recanting122414824re__canting
rechanging1746044re_changing
recladding1543974re_cladding
reclaiming1546584re_claiming
reclasping15105084re_clasping
recleaning1336754reclean_ing
reclining121112284re_clin_ing
redamaging1543764redama_ging
redemanding1643484redemanding
redlining111210294re_dlin_ing
reearning1039054reea_rn_ing
reenlarging1342474reenlarging
refacing142512814re__fa_cing
refalling132010424refal__ling
refencing15188854re__fencing
referencing1744494referencing
reflagging1643474re_flagging
reflating132514714re_fla_ting
regaining112411084rega_in_ing
regaling10315364regal___ing
regelating1239954regela_ting
reglazing2046554re_gla_zing
regranting1238324re_granting
regulating12310064regula_ting
rehanging1437564re__hanging
reimplanting1752614reimplanting
relapsing1236844re__lapsing
relating92725444re__la_ting
relaunching1742244rela_unching
relaxing162612634re__la_xing
relaying122515154re__la_ying
relending112412024re__lending
relenting102716774re__lenting
relining93218744re__lin_ing
relinking1458254re__linking
reloaning10710484re_loan_ing
remaining122212794rema_in_ing
remanding132211144re__manding
remanning12229034re__manning
renouncing1345104re_nouncing
repainting13128974repa_inting
replating122217394re_pla_ting
replaying15259604re_pla_ying
replunging1443954re_plunging
resaluting1137394resal_uting
reslating102516994re_sla_ting
respacing1438894re_spa_cing
resplicing1546294respl_icing
retaining102114734reta_in_ing
retaliating1248874retaliating
retallying1464704retal_lying
retracing12313294re_tra_cing
revaluating1545894revaluating
revaluing1337304reval__uing
reverencing1743834reverencing
rewakening1843794rewaken_ing
romancing1446044r__omancing
ropedancing1751714ropedancing

Search took 9 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 Filter1786911488190.1731032896.0
2DLD Change Limit1488191198.42317668.2
3Display Results1191190.0601983.3
 (SQL Overall)1786911198.65620643.6
 
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.