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

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

235 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
situate741078(None) 
sinuate7412161sinuate
situated938031situated
situates8310371situates
actuate9311442actuate
citrate92216802citrate
liquate1638422liquate
nitrate72017012nitrate
resituate948612resituate
satiate7315402satiate
saturate8312812saturate
scutate9310322scutate
sigmate10710142sigmate
simulate10311132simulate
sinuated938412sinuated
sinuates8310962sinuates
state56237332s_t_ate
titrate72215572titrate
vitiate103412952vitiate
vittate10409732vittate
actuated1138743actuated
actuates10310313actuates
acuate8315633_acuate
agitate8312063agit_ate
airdate8311323airdate
arcuate9311963arcuate
astute6310763astu_te
bijugate1843513bijugate
binate8419773bi_nate
bistate9313823bistate
ciliate9514603ciliate
cirrate92413493cirrate
citrated112712253citrated
citrates102315093citrates
dictate10311663dictate
dilate73220693di_late
dilute72911803dilu_te
diquat1639763diquat_
diquats1745983diquats
disrate81418523disrate
eluate62315433_eluate
equate152012463_equate
estate64719763est_ate
estimate10912003estimate
estivate111010003estivate
extubate1745103extubate
figurate1237193figurate
filiate10414233filiate
filtrate1148223filtrate
fissate103010033fissate
fistulate1246453fistulate
fixate1638733fi_xate
guttate8328903guttate
habituate1443923habituate
hesitate1169973hesit_ate
ideate7313683_ideate
imitate9310873imit_ate
ingate73018243_ingate
initiate8412693initiate
inmate82917363_inmate
innate63917313_innate
insinuate945963insinuate
intubate1047533intubate
iodate7313503_iodate
irate55627983_i_rate
isolate7313923isolate
iterate71119113_iterate
librate93214233librate
liftgate1243413liftgate
ligate72519253li_gate
ligulate92510253ligulate
limbate1139213limbate
lineate7815153lineate
liquated1835493liquated
liquates1737453liquates
literate81216893literate
litigate948303litigate
maturate10312613maturate
metate82720533met_ate
micturate1366643micturate
migrate101314173migrate
minute83414293minu_te
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
mitigate1148693mitigate
mutate83017483mut_ate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrated92213153nitrated
nitrates82516223nitrates
nitrite72314463nitrite
notate63217863not_ate
nutate63017373nut_ate
obturate1077773obturate
outate62923403out_ate
outdate83016423outdate
outrate72323183outrate
picrate112014143picrate
pileate93815923pileate
pinnate93613743pinnate
pirate82322883pi_rate
quate144521413__quate
resituated1147323resituated
resituates1047753resituates
ritual6310623ritua_l
rituals738353rituals
rotate63320343rot_ate
saccate111311763saccate
sagittate1043603sagittate
salute64418023salu_te
sanitate8612043sanit_ate
sate45556103s___ate
satiated9311603satiated
satiates8314633satiates
saturated1038993saturated
saturater947903saturater
saturates9811603saturates
saute55028083s_au_te
savate9313783s_avate
scutage1036333scutage
scute75520943s_cu_te
seatmate1048573seatmate
sedate73019803s_edate
senate63725143s_enate
sensate7311883sensate
septate9511873septate
seriate73722473seriate
serrate73017543serrate
setae56026223set_a_e
shipmate1546153shipmate
shitake1455623shit_ake
shute84520353s_hu_te
sibilate1049533sibilate
sienite7312713sienite
signage937773signage
silage72715303si_lage
silane62718053si_lane
silicate10312623silicate
silvae92811093silva_e
simulated1238283simulated
simulates1139853simulates
sinkage1287263sinkage
sinuately1243703sinuately
sitar54820543sit_a_r
sitars65417593sit_ars
site47052413si___te
sitten64113823sit__ten
sitter63323383sit__ter
situating1038883situating
situation949423situation
situp74414063situ__p
situps8538783situ_ps
situs55019233situ__s
situses72710493situses
sixte126216583si__xte
skate94721553s__kate
slate55438283s__late
solate64526073s_olate
solute64016663solu_te
solvate102710213solvate
sorbate9311733sorbate
soutane7312063soutane
spate74731583s__pate
spatulate11107173spatulate
spicate113214193spicate
spiculate132210163spiculate
spinate93114813spinate
square154513363s_quare
squat143720143s_quat_
squats153712963s_quats
stacte82113913s_tacte
stade64825303s_t_ade
stage65330193s_t_age
stake95927533s_t_ake
stale55637103s_t_ale
stane55933003s_t_ane
stare54440263s_t_are
stat47352693s_t_at_
stated75427833s_t_ated
stater64427563s_t_ater
states64337083s_t_ates
stats55933363s_t_ats
statue66015323s_t_atue
statute7419323statu_te
stave85324993s_t_ave
stimulate1148233stimulate
stipulate1147323stipulate
stoae55024263s_toa_e
stoat57135953s_toat_
stoats65117483s_toats
stomate9313123stomate
strafe95215983s_trafe
strake104017393s_trake
strata63616283s_trata
strath93216373s_trath
strati63518903s_trati
striate74218953striate
stunt55328173s_tunt_
stunted83010403s_tunted
stunts65615253s_tunts
stupe75217753s_tu_pe
sturt56028963s_turt_
sturts63915143s_turts
stutter72911463s_tutter
stylate10179773stylate
suave83519873s__uave
sublate9315363sublate
subulate10312743subulate
suitcase1043893suitcase
suite54829563s__uite
sulcate9314423sulcate
sulfate10311653sulfate
summate113611663summate
suture6313203sutu_re
tate44748603__t_ate
titanate897173titanate
titivate1146803titivate
titrated92611683titrated
titrates82314663titrates
toluate7159343toluate
triturate947483triturate
tubate82813173__tubate
ustulate868323ustulate
valuate102512733valuate
vibrate122811523vibrate
violate10311553violate
virgate1138733virgate
vitae84217633vit_a_e
vitiated12289223vitiated
vitiates112311433vitiates
vittae93911003vitta_e
zincate1838533zincate

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272357.48317910.9
3Display Results2352350.0802937.5
 (SQL Overall)1786912357.70323197.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.