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

163 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
outstate8141199(None) 
outskate12168011outskate
outstare81410691outstare
outstated10169811outstated
outstates91710751outstates
guttate8328902gut_tate
outate62923402ou__tate
outdate83016422out_date
outrate72323182out_rate
outsat62920282outs_at_
outshame1346742outshame
outskated14176832outskated
outskates13177152outskates
outstand938042outstand
outstared10188422outstared
outstares91610182outstares
outstart81611282outstart
outstarted1155072outstarted
outstarts9176322outstarts
outstay1047682outsta_y
outstayed13185932outstayed
outstays1156622outstays
outsware11168842outsware
outtake11310792out_take
substate101711092substate
unstate71916212_unstate
upstate91610492_upstate
antistate9410143antistate
apostate1049853apostate
aristate8312133aristate
automate10411943automate
bistate9313823_bistate
bursate94111203burs_ate
butylate1345213butylate
butyrate1346203butyrate
costate94019273_costate
cristate10310603cristate
curtate9312643cu_rtate
cuspate1138233cu_spate
cuttage10318343cut_tage
downstate1344613downstate
estate64719763__estate
gestate83614073_gestate
guttae73210583gut_ta_e
guttated10266873gut_tated
hastate10313913_hastate
instate71616483_instate
intestate9159873intestate
lustrate8310443lustrate
misstate10711343misstate
multistate1245513multistate
mutate83017483mu__tate
mutilate10312273mutilate
nutate63017373nu__tate
obturate1077773obturate
octette946423octet_te
offstage1541903offstage
onstage838363o_nstage
ostomate1049573ostomate
ouistiti843243ouistiti
outage72017533ou__tage
outbake13310773out_bake
outblaze1996013outblaze
outbrave1357133outbrave
outcaste10119613outcaste
outdare83113403out_dare
outdated1012513193out_dated
outdates93114743out_dates
outdebate1243163outdebate
outeat62824533out_eat_
outeaten8310423out_eaten
outeats72215703out_eats
outface123011973out_face
outgave11259563out_gave
outgaze17239223out_gaze
outglare937383outglare
outpace112613023out_pace
outplace1257913outplace
outquote1775293outquote
outrace92418553out_race
outrage82616893out_rage
outrated92219323out_rated
outrates82421373out_rates
outrave102614413out_rave
outsaid81210923outs_aid
outsail71411413outs_ail
outsang83411273outs_ang
outsaw92610283outs_a_w
outsay92611873outs_a_y
outsays102710403outs_ays
outscore10169203outscore
outsee63121803outs__ee
outsert72819513outsert_
outserts8309803outserts
outserve11157203outserve
outset64027453outs_et_
outsets73514923outs_ets
outshamed1545313outshamed
outshames1445923outshames
outshine11310723outshine
outshone1149343outshone
outshot10312103outshot_
outside82414193outs_ide
outsit63620893outs_it_
outsits73215253outs_its
outsize162411753outs_ize
outsmart10168923outsmart
outsmarted1344323outsmarted
outsmarts11155143outsmarts
outsmile1046973outsmile
outsmoke1445753outsmoke
outsnore8187683outsnore
outsoar739493outsoa_r
outsoared10157593outsoared
outsoars838853outsoars
outsole71013433outs_ole
outspan938743outspa_n
outspans1038223outspans
outspoke1446493outspoke
outstands1045543outstands
outstating1139363outstating
outstation1046163outstation
outsteer837553outsteer
outstood945933outstood
outstride1085783outstride
outstrip1045083outstrip
outstrive1265083outstrive
outstrode1065423outstrode
outstroke1365213outstroke
outstrove1264713outstrove
outstudy1242923outstudy
outstunt847223outstunt
outstunted1143183outstunted
outstunts943613outstunts
outswam1246613outswa_m
outswore11168673outswore
outtakes12310033out_takes
outtalk1138233out_talk
outtask1137053out_task
outtrade938343outtrade
outvote1038803out_vote
outwaste11147943outwaste
outwrite1139453outwrite
outwrote1137723outwrote
overstate121010863overstate
prostate10314533prostate
pulsate9510233puls_ate
punctate1246473punctate
restate73824883_restate
state56237333___state
substage11117183substage
substates111410333substates
substrate11178793substrate
testate73916233_testate
tristate8311033tristate
tungstate1042873tungstate
unstated91615813_unstated
unstates81314993_unstates
upstage10167443_upstage
upstare9158683_upstare
upstater10156663_upstater
upstates10189643_upstates
vittate10409733vit_tate

Search took 9 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 Limit1461621637.54619369.5
3Display Results1631630.0632587.3
 (SQL Overall)1786911638.04522211.4
 
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.