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

199 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
situates831037(None) 
sinuates8310961sinuates
situate7410781situate_
situated938031situated
actuates10310312actuates
citrates102315092citrates
liquates1737452liquates
nitrates82516222nitrates
resituates1047752resituates
satiates8314632satiates
saturates9811602saturates
simulates1139852simulates
sinuate7412162sinuate_
sinuated938412sinuated
situses72710492situ_ses
states64337082s_t_ates
titrates82314662titrates
vitiates112311432vitiates
actuate9311443actuate_
actuated1138743actuated
agitates9310883agit_ates
airdates939723airdates
ciliates10413453ciliates
citrate92216803citrate_
citrated112712253citrated
dictates11311383dictates
dilates83220663di_lates
dilutes82911973dilu_tes
diquats1745983diquat_s
disrates91118153disrates
eluates72014683_eluates
equates162012323_equates
estates74520183est_ates
estimates11911363estimates
estivates12109753estivates
extubates1844843extubates
filiates11412663filiates
filtrates1247733filtrates
fixates1737393fi_xates
habituates1543633habituates
hesitates1269793hesit_ates
ideates8313733_ideates
imitates10310503imit_ates
ingates82716913_ingates
initiates9411183initiates
inmates92715783_inmates
insinuates1045463insinuates
intubates1147123intubates
iodates8312903_iodates
isolates8613513isolates
iterates81317823_iterates
librates103412953librates
liftgates1343513liftgates
ligates82318383li_gates
liquate1638423liquate_
liquated1835493liquated
literates91415653literates
litigates1048003litigates
litotes7311183lit_otes
maturates11311763maturates
metates92720013met_ates
micturates1456093micturates
migrates111112853migrates
minutes93513443minu_tes
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
mitigates1248253mitigates
mutates92215793mut_ates
nictates1039593nictates
nidates8311893ni_dates
niobates1037283niobates
nitrate72017013nitrate_
nitrated92213153nitrated
nitrites82313453nitrites
notates72817483not_ates
nutates73214973nut_ates
obturates1157003obturates
outdates93114743outdates
outrates82421373outrates
picrates122013213picrates
pirates93020333pi_rates
resituate948613resituate_
resituated1147323resituated
rituals738353ritua_ls
rotates72819773rot_ates
salutes73716253salu_tes
sanitates9611733sanit_ates
sates54949323s___ates
satiate7315403satiate_
satiated9311603satiated
saturate8312813saturate_
saturated1038993saturated
saturater947903saturater
saturaters1045563saturaters
sautes63924913s_au_tes
savates10312953s_avates
scutages1136503scutages
scutate9310323scutate_
scutes85219193s_cu_tes
seatmates1157823seatmates
sedates83418043s_edates
senates73322613s_enates
sensates8511143sensates
seriates82620673seriates
serrates82617023serrates
shipmates1645953shipmates
shitakes1546113shit_akes
shutes93518223s_hu_tes
sibilates1148443sibilates
sienites8311913sienites
sigmate10710143sigmate_
signages1037483signages
silages82514443si_lages
silanes72517163si_lanes
silicates11311523silicates
simulate10311133simulate_
simulated1238283simulated
sinkages1386853sinkages
sinuately1243703sinuately
sinuses73011593sinu_ses
sitars65417593sit_a_rs
sites56045433si___tes
sitten64113823sit__ten
sitter63323383sit__ter
sitters74221553sit__ters
situating1038883situating
situation949423situation
situations1038433situations
situps8538783situ__ps
situs55019233situ___s
sixtes133612403si__xtes
skates104219403s__kates
slates64934063s__lates
solates73523853s_olates
solutes73515263solu_tes
solvates11249673solvates
sorbates10311103sorbates
soutanes8312933soutanes
spates85028173s__pates
squares163714463s_quares
squats153712963s_quat_s
stactes91914633s_tactes
stades74626243s_t_ades
stages75629493s_t_ages
stakes103927293s_t_akes
stales65538293s_t_ales
stanes64933403s_t_anes
stapes85028733s_t_apes
stares66038753s_t_ares
stases64225563s_t_ases
state56237333s_t_ate_
stated75427833s_t_ated
stater64427563s_t_ater
staters73922343s_t_aters
stats55933363s_t_at_s
statues74614903s_t_atues
status65515213s_t_atus
statutes8368893statu_tes
staves94525193s_t_aves
stimulates1247383stimulates
stipites1039653stipites
stipulates1256683stipulates
stoats65117483s_toat_s
stomates10313343stomates
strafes104516003s_trafes
strakes114218073s_trakes
stratas73013583s_tratas
straths102711723s_traths
stratus73011733s_tratus
striates83417083striates
studies82413863s_tudies
stunted83010403s_tunted
stunts65615253s_tunt_s
stupes84116953s_tu_pes
sturts63915143s_turt_s
stutter72911463s_tutter
stutters83210473s_tutters
sublates10315003sublates
suitcases1144453suitcases
suites63727403s__uites
sulfates11310793sulfates
summates122610493summates
sutures7314223sutu_res
tates55444983__t_ates
titanates976093titanates
titivates1246433titivates
titrate72215573titrate_
titrated92611683titrated
toluates8138903toluates
triturates1046763triturates
valuates112811203valuates
vibrates132210613vibrates
violates11311193violates
virgates1237923virgates
vitiate103412953vitiate_
vitiated12289223vitiated
vittate10409733vittate_
zincates1937743zincates

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621996.72021750.3
3Display Results1991990.0932139.8
 (SQL Overall)1786911997.24924650.4
 
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.