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

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

176 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
boite7442632(None) 
bite66547001b_ite
blite76225351blite
boites84322701boites
axite125218252axite
bait66556002bait_
baited95319242baited
baiter84422552baiter
baith108023132baith
baits76630582baits
baize164717392baize
barite84224812barite
baste74829982baste
bate66552422b_ate
beige81515382beige
bice86235562b_ice
bide76041502b_ide
bike106532602b_ike
bile66147182b_ile
bine66650862b_ine
biome94916992biome
biota74516822biota
biotite9311032biotite
bise66437102b_ise
bit57070902b_it_
biter75030032b_iter
bites75641172b_ites
bits66148162b_its
bitt65545812b_itt
bize155926292b_ize
blate75933782blate
blites84721212blites
blithe115810862blithe
blitz165318132blitz
boat66360312boat_
boated94221972boated
boatel84314092boatel
boater84622092boater
boats75635152boats
bocce114313112bocce
boche124216952boche
bode75838752bo_de
bodice11711422bodice
bogie89524102bogie
bogle85821682bogle
boil66335182boi_l
boiled95020952boiled
boiler84319272boiler
boils75427192boils
boing84725552boing
boink115516332boink
bole66448692bo_le
bolete8519612bolete
bolide9515562bolide
bolt66254172bolt_
bolted94617802bolted
bolter83920752bolter
bolts76232112bolts
bombe115519312bombe
bone65949322bo_ne
bonita8312942bonita
bonito8313432bonito
bonne75124712bonne
bonze165119352bonze
boot67759372boot_
booted94822732booted
bootee84323022bootee
booth105522012booth
bootie85421162bootie
boots75837972boots
booty106125912booty
booze164718912booze
borate85026152borate
bore66051332bo_re
boride9415902boride
borne77926792borne
bornite9311182bornite
bort65960962bort_
borts76735452borts
borty105522832borty
bortz165722202bortz
bot59680402bo_t_
bota66236502bo_ta
botel75121862bo_tel
both96533432bo_th
bots66453952bo_ts
bott66548572bo_tt
bottle84916072bottle
botts75224862botts
boule74828042boule
bouse75931852bouse
bout66353292bout_
bouts75131312bouts
bovine11712432bovine
bowse105420632bowse
bribe94820782bribe
bride86425532bride
brie65837902bri_e
brine75132272brine
brit66350152brit_
brith104924372brith
brits76433082brits
britt75732232britt
brute75321782brute
bute66739672b_ute
butte74924292butte
byte96521812b_yte
cite65640342_cite
comte96125472comte
conte76633202conte
cote66648732co_te
dite55547552_dite
doit56347852doit_
doited85016632doited
doits66223672doits
dote55442882do_te
ebonite9310292ebonite
elite56230182elite
evite85317682evite
flite85424962flite
fomite113314072fomite
forte86131462forte
gite55438612_gite
goiter74116202goiter
goitre7349002goitre
hoise85224772hoise
iolite63221982iolite
kite85338242_kite
koine9516482koine
lite47054542_lite
loiter64619172loiter
lotte54923852lotte
mite66249412_mite
moire71017322moire
monte75829772monte
moste75925082moste
mote67048082mo_te
motte75526972motte
nite45943582_nite
noise55723732noise
norite63221132norite
note46239962no_te
obit66837082obit_
obits74617552obits
oolite63319602oolite
podite93315352podite
pointe84619312pointe
poise75127892poise
polite83625072polite
quite144621462quite
rite45849452_rite
rote46249022ro_te
rotte54625932rotte
route55132072route
site47052412_site
skite95120052skite
smite75224872smite
somite84519372somite
sopite84917712sopite
spite75430662spite
suite54829562suite
toile54626492toile
toit46353062toit_
toited74016752toited
toits55327472toits
torte55431702torte
tote46643672to_te
trite54730032trite
unite54828382unite
voice104915322voice
voile84719722voile
volte85321302volte
vote74728622vo_te
white114920302white
wite75443272_wite
write85522832write

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001761.53035163.4
3Display Results1761760.0463826.1
 (SQL Overall)1786911761.88994595.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.