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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
balletic124807(None) 
allelic9118172_allelic
aloetic9313182_aloetic
balladic1345332balladic
ballet84733972ballet__
ballets93719512ballet_s
ballistic1346612ballistic
bathetic1548572bathetic
bulletin1046772bulletin
acetic10314503_a_cetic
albitic1139133_albitic
allergic11125373_allergic
allylic12155843_allylic
analgetic12156493analgetic
aphetic142912853_aphetic
aplitic11311743_aplitic
ascetic11310063_ascetic
athletic13118643athletic
atretic9313923_atretic
auxetic1637143_auxetic
baldric12166403ba_ldric
balled94926893balle__d
baller83825203balle__r
ballerina1146483ballerina
ballers94421013balle_rs
ballistics1444033ballistics
ballot84624093ballot__
balloted1189043balloted
balloter1078893balloter
balloting1238383balloting
ballots94116033ballot_s
ballute938543ballut_e
ballutes1037523ballutes
balsamic1463803balsamic
barleduc1342143barleduc
barytic1437823ba_rytic
basaltic1245153basaltic
bauxitic1943623bauxitic
billet86029723billet__
billeted1137643billeted
billeter1037563billeter
billeting1236633billeting
billets94516153billet_s
biolytic1546773biolytic
bluetick1643333b_luetick
boleti8413403b_oleti_
bullet84528613bullet__
bulleted1138393bulleted
bulleting1236643bulleting
bulletins1146333bulletins
bullets93516393bullet_s
calcitic1148193calcitic
callet84536763callet__
callets93821703callet_s
dalmatic1348683dalmatic
galactic13106533galactic
galenic1038693ga_lenic
gallein8299043galle_in
galleria946473galleria
gallet73630853gallet__
galleta8399643gallet_a
galletas9308133galletas
galleted1038213galleted
galleting1137623galleting
gallets83517403gallet_s
gallic9411643gall__ic
gametic1239993ga_metic
illitic939253_illitic
luetic8310383__luetic
magnetic1349233magnetic
malefic1486323ma_lefic
mallei84414633malle_i_
mallet84433053mallet__
mallets93318493mallet_s
marlitic1238343marlitic
palladic1346113palladic
pallet84232653pallet__
palleted1139863palleted
palleting1238733palleting
palletise11127633palletise
palletize20127173palletize
pallets93919303pallet_s
pallette1039513pallette
paretic113016673pa_retic
pathetic15410953pathetic
phyletic1847213phyletic
rabietic1245503rabietic
sallet63734543sallet__
sallets73719653sallet_s
saluretic1144133saluretic
sylleptic1653153sylleptic
tabetic1138463ta_betic
tallitim1065503tallitim
valeric1238303va_leric
villatic1346223villatic
wallet93327093wallet__
wallets103914833wallet_s

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.1701051123.5
2DLD Change Limit146162977.50319480.5
3Display Results97970.0303233.3
 (SQL Overall)178691977.70323197.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.