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

90 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
ballonets114672(None) 
ballonet10314501ballonet_
ballets93719512ball__ets
ballonnes1145322ballonnes
ballons93916962ballon__s
balloters1157672balloters
ballots94116032ballo__ts
baloneys1334662ba_loneys
baronets101410902ba_ronets
bayonets13135582ba_yonets
falconets1444812falconets
abalones1038753abalone_s
alkanets12366233_alkanets
allonges937313_allonges
allonyms1344363_allonyms
allots64019173_allo__ts
allovers1137673_allovers
almoners1068133_almoners
baclofens1642173baclofens
bailments1346463bailments
bailouts1036613bailo_uts
balconies1347753balconies
baldness1137043ba_ldness
balkiness1556903balkiness
balklines1536743balkline_s
ballades114211643ballade_s
ballasts1037933ball_asts
ballers94421013ball__ers
ballet84733973ball__et_
ballies93725743ball_ie_s
ballon84117493ballon___
ballonne1045243ballon_ne
ballooned1245103balloone_d
balloonist1254683balloonist
balloonists1353023balloonists
balloons103110523ballo_ons
ballot84624093ballo__t_
balloted1189043ballote_d
balloter1078893ballote_r
ballpoints1442903ballpoints
ballsiest1145413ballsiest
ballutes1037523ballute_s
balminess1356593balminess
baloney1237483ba_lone_y
bannets94013843ba__nnets
baroness101210063ba_roness
baronet91022203ba_ronet_
basinets1039063ba_sinets
bassinets1146323bassinets
bayonet121212213ba_yonet_
bellowers14177623bellowers
billets94516153bill__ets
billons93013363billon__s
blazoners2043863blazoners
bolloxes1736833bolloxe_s
boloneys1334503b_oloneys
bullets93516393bull__ets
burgonets1243513burgonets
callants104112143callan_ts
callets93821703call__ets
calloses10313393callose_s
callowest1445823callowest
callowness1543013callowness
calzones1948763calzone_s
canzonets2044483canzonets
falconers1445323falconers
falconet13410363falconet_
fallouts1137883fallo_uts
fallowness1642943fallowness
gallants93310373gallan_ts
gallets83517403gall__ets
gallnuts943923gall_nuts
gallons83015953gallon__s
galloots9268963gallo_ots
gallopers12136323gallopers
gillnets934733gill_nets
halloes104021523hallo_e_s
hallowers15137723hallowers
haplonts1345773haplon_ts
jaconets1745613ja_conets
mallets93318493mall__ets
pallets93919303pall__ets
sallets73719653sall__ets
sallowest1246563sallowest
sallowness1343753sallowness
solonets838233_solonets
tallness837103tall_ness
wallets103914833wall__ets
wallopers14136273wallopers
wallowers15127653wallowers

Search took 7 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 Limit148641906.45323034.4
3Display Results90900.0501800.0
 (SQL Overall)178691906.93925751.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.