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

154 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
smite7522487(None) 
mite66249421_mite
samite83020601samite
site47052421s_ite
skite95120061skite
smile74823921smile
smit65138411smit_
smiter83616411smiter
smites83921921smites
smith107818051smith
smote75820281smote
somite84519371somite
spite75430661spite
suite54829561suite
amice96122872amice
amide86128492amide
amie66339852ami_e
amine75835382amine
amity10416092amity
axite125218252axite
bite66547012_bite
blite76225352blite
boite74426322boite
cite65640352_cite
dite55547562_dite
elite56230182elite
emit65438422emit_
emits75421472emits
emote75421192emote
evite85317682evite
flite85424962flite
fomite113314072fomite
gite55438622_gite
imide85716902imide
imine75821062imine
kite85338252_kite
lite47054552_lite
mate65154222_mate
mete64438132_mete
mice87442242_mice
mike105535302_mike
mile66352582_mile
mime85736412_mime
mine67256182_mine
mire66748242_mire
mise66043592_mise
miter75734792_miter
mites75141802_mites
mitre75522422_mitre
mitt66145502_mitt
mity95528222_mity
mote67048082_mote
mute65136872_mute
nite45943592_nite
omit65337372omit_
omits75018262omits
quite144621462quite
rite45849462_rite
saice75424052saice
saith85826552saith
saithe94713912saithe
samites93118712samites
sate45556102s_ate
saute55028082saute
scute75520942scute
seine55732872seine
seise54727852seise
seize143819502seize
sente56432882sente
shine85533092shine
shire84727132shire
shit76745942shit_
shits84731172shits
shive114423422shive
shote85526102shote
shute84520352shute
sice65545602s_ice
side55444502s_ide
sike87138792s_ike
simile83115632simile
sine46560632s_ine
sipe67341052s_ipe
sire46150422s_ire
sit35877762s_it_
sited65130742s_ited
sites56045432s_ites
sith75435162s_ith
sits45050212s_its
sixte126216582sixte
size135630972s_ize
skate94721552skate
skit85437542skit_
skited114313482skited
skites104418042skites
skits94721872skits
skive124614122skive
slate55438282slate
slice74925822slice
slide64725422slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
smaze165012932smaze
smidge10378482smidge
smiled93716432smiled
smiler83916682smiler
smiles84522292smiles
smiley114012302smiley
smirk116612752smirk
smiters93414362smiters
smiths114711022smiths
smithy14508272smithy
smitten936692smitten
smoke115015822smoke
smut66629782smut_
smuts75415712smuts
snide64318732snide
snipe75320572snipe
snit46342472snit_
snits54124832snits
somites94219122somites
sopite84917712sopite
spate74731582spate
spice95528812spice
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spit65545082spit_
spited94820442spited
spites84127332spites
spits74429552spits
spitz166017972spitz
sprite84421772sprite
state56237332state
stile54931572stile
stime76521802stime
stipe76523372stipe
suit45649872suit_
suited74019422suited
suiter64121812suiter
suites63727402suites
suits55028052suits
swine85625302swine
swipe105217082swipe
swith115917402swith
swithe124010682swithe
swive115316192swive
trite54730032trite
unite54828382unite
white114920302white
wite75443282_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.296603685.8
2DLD Change Limit538001541.50035866.7
3Display Results1541540.0305133.3
 (SQL Overall)1786911541.82697859.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.