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

166 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
blite7622535(None) 
bite66547001b_ite
blate75933781blate
blites84721211blites
blithe115810861blithe
blitz165318131blitz
boite74426321boite
elite56230181elite
flite85424961flite
lite47054541_lite
ablate82219212ablate
alate55340322alate
albite8313312albite
alike95523962alike
aline57243152aline
alit46155692alit_
alive85722512alive
aplite8316392aplite
axite125218252axite
bait66556002bait_
baited95319242baited
baiter84422552baiter
baith108023132baith
baits76630582baits
baize164717392baize
barite84224812barite
baste74829982baste
bate66552422b_ate
beige81515372beige
belie75630382beli_e
belike124616282belike
belive115415302belive
bice86235562b_ice
bide76041482b_ide
bike106532602b_ike
bile66147182b_ile
bilge87618912bilge
bine66650862b_ine
bise66437102b_ise
bit57070902b_it_
biter75030032b_iter
bites75641172b_ites
bits66148162b_its
bitt65545812b_itt
bize155926292b_ize
blade85923332blade
blae66134642bl_ae
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat_
blats75132502blats
blaze165520832blaze
blet66247672blet_
blets75324942blets
blimey13468452blimey
blimp115612942blimp
blimy125212822blimy
blin67228172bli_n
blind86319322blind
blini75519272blini
blink115720142blink
blintz1788842blintz
blintze1833902blintze
blip88322772bli_p
blips95615782blips
bliss75616912bliss
blister94415312blister
blither124812172blither
blitzed19336532blitzed
blitzer18447662blitzer
blitzes18408702blitzes
bloke114316632bloke
blot65842322blot_
blots75626172blots
blue65328462bl_ue
bluet75631192bluet
blume95619892blume
blype12429672blype
boites84322702boites
bolete8519612bolete
bolide9515562bolide
bribe94820782bribe
bride86425532bride
brie65837902bri_e
brine75132272brine
brit66350152brit_
brith104924372brith
brits76433082brits
britt75732232britt
brute75321782brute
bute66739672b_ute
butte74924292butte
byline11311642byline
byte96521812b_yte
cite65640342_cite
clime95720892clime
cline76428532cline
dite55547552_dite
elate55335882elate
elide64922642elide
elites66027122elites
elute54822572elute
evite85317682evite
flit76539272flit_
flited104616582flited
flites95122442flites
flits85625222flits
flute86823752flute
flyte115713942flyte
gite55438612_gite
glide74521592glide
glime85620192glime
glitz154916372glitz
glute66020902glute
halite93624232halite
illite63414922illite
iolite63221982iolite
kite85338232_kite
late47560482_late
lice66045062_lice
lie38264522_li_e
life75433732_life
like86040842_like
lime66244932_lime
line46965572_line
lipe66839732_lipe
lire47845292_lire
lit39377312_lit_
liter54736342_liter
lithe84922012_lithe
litre55421462_litre
lits46252492_lits
litu47631562_litu
live76540992_live
lute46341012_lute
mite66249412_mite
nite45943582_nite
oblate82214742oblate
oblige937652oblige
olive84817152olive
oolite63319602oolite
pelite84323002pelite
plate74635112plate
plie65127392pli_e
polite83625072polite
quite144621462quite
rite45849452_rite
site47052412_site
skite95120052skite
slate55438282slate
slice74925822slice
slide64725412slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
smite75224872smite
spite75430662spite
suite54829562suite
trite54730032trite
unite54828382unite
white114920302white
wite75443272_wite
write85522832write
zlote143912942zlote

Search took 3 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.326548131.9
2DLD Change Limit538001661.62633087.3
3Display Results1661660.0463608.7
 (SQL Overall)1786911661.99889434.9
 
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.