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

275 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
squirt15381293(None) 
quirt144624231_quirt
squint154214791squint
squire155912461squire
squirm17387671squirm
squirts16348011squirts
asquint16208322asquint
esquire16376602esquire
quart144027852_quart
quiet144530732_quiet
quilt144125102_quilt
quint144529902_quint
quire144917132_quire
quirk184011002_quirk
quirts154213552_quirts
quit136136512_qui_t
shirt84533902s_hirt
skirt95624662s_kirt
spirt75032952s_pirt
spurt77227982spu_rt
square154513362square
squark19438112squark
squat143720142squ_at
squib163710502squi_b
squibs17317452squibs
squid154211902squi_d
squids16409802squids
squill1537232squill
squints16339032squints
squinty19287062squinty
squired173710062squired
squires163812842squires
squirms18376342squirms
squirmy21374292squirmy
squirted1845792squirted
squirter1746522squirter
squish1838572squish
sturt56028962stu_rt
suint55638182s_uint
suit45649872s_ui_t
acquire1835603acquire
acquit17610323acqui_t
airt45757783__airt
begirt9412683begirt
blurt77625623blu_rt
bruit76126723brui_t
built74325923_built
court75532773cou_rt
curt67051713_cu_rt
dirt55550383__dirt
disquiet1879923disquiet
duit56241583_dui_t
engirt71112613engirt
enquire16287213enquire
enquiry19254043enquiry
equid154610323equi_d
equids16439143equids
equine151711573equine
equip16467263equi_p
equips17387193equips
equity1838103equity
esquired18315083esquired
esquires17266213esquires
faquir1834313faquir_
faquirs1943863faquirs
flirt87424753_flirt
fruit85122223frui_t
girt56646423__girt
guilt65125573_guilt
guiro63712093_guiro
hurt77142573_hu_rt
inquiet16311413inquiet
inquire16227993inquire
inquiry19254703inquiry
mesquit18387953mesqui_t
quaint15415173_quaint
quant143624813_quant
quare143920543_quare
quark184614123_quark
quarte154115323_quarte
quarto153511123_quarto
quarts154715933_quarts
quartz244212103_quartz
qubit164218993_qubit
quern143610403_quern
query174212083_query
quest144121323_quest
quick204311063_quick
quid144922353_qui_d
quids154917463_quids
quiets154014373_quiets
quiff201111563_quiff
quill148413773_quill
quilts154112543_quilts
quin135823923_qui_n
quins144819853_quins
quinta153312373_quinta
quinte153414523_quinte
quints154316563_quints
quip154818623_qui_p
quips164713373_quips
quipu164811643_quipu
quired163711953_quired
quires154015753_quires
quirks19419113_quirks
quirky22435533_quirky
quirted17369213_quirted
quite144621463_quite
quits144122353_quits
quiz224920003_qui_z
quoit143819863_quoit
require16148653require
sabir75917003sabir_
sabirs85414633sabirs
sadist74221353sadist
saint55147073s_aint
satire63218003satire
sault55834963sau_lt
saury84317223sau_ry
scart76139773s_cart
schist11312653schist
schuit1139563schui_t
script105717903script
sculpt104412693sculpt
scurf104719323scu_rf
scurry11419593scurry
scut65835543scu__t
seagirt8310153seagirt
sequent16410323sequent
sequin1538523sequi_n
sequins1637863sequins
sexist133013483sexist
shaird10288703shaird
shairn9269063shairn
shift114225143s_hift
shire84727133s_hire
shirk124817843s_hirk
shirr84716923s_hirr
shirts94918343s_hirts
shirty124312563s_hirty
shist84829613s_hist
shit76745943s_hi_t
short85040533s_hort
shrift12413543shrift
shunt85226513shu_nt
shut76137593shu__t
sift710740663s__ift
silt46558193s__ilt
sir35746673s__ir_
sire46150413s__ire
sirs44338333s__irs
sit35877753s__i_t
skint95629223s_kint
skirl96012913s_kirl
skirr94810543s_kirr
skirts104111503s_kirts
skit85437533s_ki_t
skort94925643s_kort
slipt76627483s_lipt
slit46250103s_li_t
sluice849513sluice
sluicy1166483sluicy
sluing74315883sluing
slur45525153slu_r_
slurb74116323slu_rb
slurp74014983slu_rp
slurry9378603slurry
slurs54123373slu_rs
slut45040593slu__t
smart75834093s_mart
smirk116612753s_mirk
smit65138413s_mi_t
smut66629783smu__t
snit46342473s_ni_t
snort54833753s_nort
sort46264813s__ort
souari6311383souari
sought106315063sought
sour45935893sou_r_
sours55230503sou_rs
soviet9720153soviet
spait75631603spai_t
speir75315363speir_
speirs85013233speirs
spilt75532223s_pilt
spire75828693s_pire
spirit83519923s_pirit
spirts85317133s_pirts
spiry105017353s_piry
spit65545083s_pi_t
splint85223283splint
split75729013spli_t
spoilt85016593spoilt
sport75935983s_port
sprint84526793sprint
sprit76736403spri_t
spuing94313363spuing
spur65321193spu_r_
spurn74815453spu_rn
spurry11429123spurry
spurs74621523spu_rs
spurts84814973spu_rts
squab163810733squ_ab
squabs17429323squabs
squad155110793squ_ad
squads164410293squads
squall1538003squall
squama1736533squama
squared173610563squared
squarer163410663squarer
squares163714463squares
squarest17338223squarest
squarks20417183squarks
squash1846833squash
squats153712963squats
squatty1964823squatty
squaw17368983squ_aw
squawk22385373squawk
squaws18438783squaws
squeak1935253squeak
squeal1538023squeal
squeg1588033squ_eg
squegs1675643squegs
squiffy2542573squiffy
squilla1635533squilla
squills1666313squills
squinch2134833squinch
squinny19274223squinny
squinted1847063squinted
squinter1747363squinter
squireen1744393squireen
squiring18177563squiring
squirish2045113squirish
squirmed2034173squirmed
squirmer1934373squirmer
squirrel17414533squirrel
squirters1835073squirters
squirting1934793squirting
squishy2244023squishy
squush1833993squush
stair54719943stair_
stairs65416333stairs
start55642313s_tart
stilt54831983s_tilt
stint57037663s_tint
stir45723253s_tir_
stirk95717413s_tirk
stirp76815503s_tirp
stirs55921623s_tirs
strict84821043strict
stript85222193stript
stunt55328173stu_nt
sturts63915143stu_rts
sucre75019103s_ucre
suer45334033s_uer_
suers55128483s_uers
suet46754823s_u_et
suing65026363s_uing
suints64617783s_uints
suite54829563s_uite
suits55028053s_uits
supra73614253s_upra
sura45740293s_u_ra
surd56433813s_u_rd
sure45447413s_u_re
surf76039313s_u_rf
surra55521343s_urra
sutra54217933s_utra
swart86234643s_wart
swift116818053s_wift
swirl84514143s_wirl
ungirt71112713ungirt
unquiet16310663unquiet
upgirt9117263upgirt
yurt76435043_yu_rt

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162755.30021267.2
3Display Results2752750.0932957.0
 (SQL Overall)1786912755.76630990.5
 
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.