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

147 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
blites8472121(None) 
bites75641171b_ites
blite76225351blite_
blitzes18408701blitzes
boites84322701boites
elites66027121elites
flites95122441flites
ablates92416902ablates
alates64833962alates
albites9313202albites
alines65735222alines
aplites9314932aplites
axites134913832axites
baited95319242baited
baiter84422552baiter
baiters94619302baiters
baits76630582bait_s
baizes174315052baizes
barites94322332barites
bastes85330382bastes
bates75846342b_ates
beiges91014402beiges
belies84631052beli_es
bices95029962b_ices
bides85536772b_ides
bikes117529472b_ikes
biles75542142b_iles
bilges94915632bilges
bines76946792b_ines
bises75435622b_ises
bite66547002b_ite_
biter75030032b_iter
biters83925242b_iters
bits66148162b_it_s
bitts75022592b_itts
bizes165923662b_izes
blades95221252blades
blames105121862blames
blares85021632blares
blate75933782blate_
blats75132502blat_s
blazes174817352blazes
blets75324942blet_s
blimey13468452blimey
blimps12588152blimps
blinds95111612blinds
blinis85313682blinis
blinks124613572blinks
blintzes1944262blintzes
blips95615782bli_ps
bliss75616912bli_ss
blisses94911512blisses
blister94415312blister
blisters104015082blisters
blithe115810862blithe
blither124812172blither
blithers134711232blithers
blithest1338082blithest
blitz165318132blit_z
blitzed19336532blitzed
blitzer18447662blitzer
blitzers19417152blitzers
blokes123813882blokes
blots75626172blot_s
blues75127042bl_ues
bluets87215492bluets
blumes105917792blumes
blypes13357542blypes
boite74426322boite_
boletes9316062boletes
bolides10515072bolides
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brines85028852brines
brises84927612brises
briths115113862briths
brits76433082brit_s
britts84813442britts
brutes86118682brutes
butes714535872b_utes
buttes84822562buttes
bylines1239242bylines
bytes105217492b_ytes
cites74435592_cites
climes104720002climes
clines84926042clines
dites66339152_dites
elates65032362elates
elides74420692elides
elite56230182elite_
elutes64020312elutes
evites94916472evites
flies85630712fli_es
flite85424962flite_
flited104616582flited
flits85625222flit_s
flutes95421782flutes
flytes123911562flytes
frites94922482frites
gites65630182_gites
glides84518862glides
glimes94717522glimes
glitzes17367562glitzes
glutes74517672glutes
halites103221192halites
illites72415012illites
iolites73819482iolites
kites95432542_kites
lies46454192_li_es
likes96231902_likes
limes75636502_limes
lines57054572_lines
litas54923772_litas
lite47054542_lite_
liter54736342_liter
liters65429882_liters
litres65220392_litres
lits46252492_lit_s
lives86133192_lives
lutes55836662_lutes
mites75141802_mites
nites55736342_nites
oblates91913242oblates
obliges1037142obliges
olives94313952olives
oolites72817842oolites
pelites93821992pelites
plates85432242plates
plies74526512pli_es
rites54442552_rites
sites56045432_sites
skites104418042skites
slates64934062slates
slices84022852slices
slides73922182slides
slimes84722042slimes
slipes84921412slipes
slits56128852slit_s
smites83921922smites
spites84127332spites
suites63727402suites
unites65024852unites
velites103417302velites
whites123919882whites
wites85536962_wites
writes94420332writes

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 Filter178691825510.1101624463.6
2DLD Change Limit825511472.14038575.2
3Display Results1471470.0463195.7
 (SQL Overall)1786911472.29677827.1
 
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.