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

271 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
squall153800(None) 
squalls1647311squalls
squally1937671squally
squill1537231squill
equal1449822equa_l
equally1936872equally
equals1538692equals
quail144314362_quail
quale143617852_quale
qualm163511182_qualm
quell144311432_quell
quill148413772_quill
quoll14379492_quoll
sall44544682s__all
scall74420372s_call
scull75315762scu_ll
shall85024052s_hall
skull94812032sku_ll
small74016262s_mall
spall74919302s_pall
squab163810732squa_b
squabs17429322squabs
squad155110792squa_d
squads164410292squads
squalid1737052squalid
squalled1835942squalled
squaller1736082squaller
squalor1644422squalor
squama1736532squama
square154513362square
squark19438112squark
squash1846832squash
squat143720142squa_t
squatly1946432squatly
squats153712962squats
squaw17368982squa_w
squawk22385372squawk
squaws18438782squaws
squeal1538022squeal
squeals1636512squeals
squilla1635532squilla
squills1666312squills
stall54722352s_tall
stull54916272stu_ll
ahull84010313ahu_ll
all36148233___all
appall10379743appall
aqua132813963aqua__
aquae142212713aqua_e
aquas142412613aqua_s
ashfall1343943ashfall
ball66043323__ball
befall114410643befall
begall92610723begall
bull65634873_bu_ll
call66838673__call
cull65929643_cu_ll
dual55928173_dua_l
dually103210063_dually
duals65620083_duals
dull56430443_du_ll
equable1849253equable
equably2136183equably
equaled17166923equaled
equalled1834863equalled
equate152012463equate
fall75535313__fall
full75229153_fu_ll
gall56335993__gall
gull54828453_gu_ll
hall75741163__hall
hull75428783_hu_ll
infall939403infall
inwall938343inwall
joual12311653joua_l
jouals1338923jouals
lall45531313__lall
lull44225763_lu_ll
mall64639373__mall
mull65128803_mu_ll
null45125313_nu_ll
pall65039343__pall
pull64731663_pu_ll
qua124821973_qua__
quack203812503_quack
quad144618703_qua_d
quads154515843_quads
quaff201311353_quaff
quag144815943_qua_g
quags154613253_quags
quai134420393_qua_i
quails153412643_quails
quais144618393_quais
quake184114643_quake
quaky214310743_quaky
qualia1559563_qualia
qualms17317243_qualms
qualmy20285803_qualmy
quant143624813_quant
quare143920543_quare
quark184614123_quark
quart144027853_quart
quash174512163_quash
quasi144015023_quasi
quass144413763_quass
quate144521413_quate
quay164618353_qua_y
quays174612043_quays
quells15359703_quells
quills153811853_quills
quilt144125103_quilt
quolls15327303_quolls
recall83815723recall
refall94314393refall
sabal75422483saba_l
sabals84618863sabals
sail45447163s__ail
sal36462883s__a_l
salal55425703s__alal
salals65120083salals
sale44959703s__ale
sally85129713s__ally
salol55222143s__alol
salp64534093s__alp
sals46851673s__als
salt45758523s__alt
saul45836523s__aul
sauls55128123sau_ls
sault55834963sau_lt
saurel6511993saurel
scald84818123s_cald
scale74629143s_cale
scalls84218203s_calls
scalp95217983s_calp
scaly104718723s_caly
scrawl11208083scrawl
scroll8310163scroll
sculk115112463scu_lk
sculls84613883sculls
sculp95314843scu_lp
seal45654373s_ea_l
seals54839693s_eals
seawall1046203seawall
sell45840613s__ell
sepal77723003sepa_l
sepals85217373sepals
sequel1556713sequ_el
sequela1663993sequela
sequels1665703sequels
serail64222673serail
seral56336383sera_l
setal56430903seta_l
sexual1338413sexua_l
sexually1845603sexually
shale85332833s_hale
shalt85534493s_halt
shaly114322863s_haly
shaul85418103s_haul
shauls94913113shauls
shawl116217573s_hawl
sheal84927703shea_l
sheals94420643sheals
shell84424123s_hell
shill85325333s_hill
shoal83920273shoa_l
shoals94215793shoals
shoaly124010773shoaly
shrill94712303shrill
shul75823153shu__l
shuln84713113shu_ln
shuls85319713shu_ls
sial45938833s_ia_l
sials54227243s_ials
sill45545153s__ill
sisal54217733sisa_l
sisals63013573sisals
skald104210173s_kald
skell94915833s_kell
skill94316723s_kill
skoal93811463skoa_l
skoals10438243skoals
skua86113153skua__
skuas95611733skua_s
skulk8479623sku_lk
skulls10429643skulls
smalls84514123s_malls
smalt74729333s_malt
smell74916233s_mell
smugly1274833smugly
snail57020203s_nail
snarl54921083s_narl
snell54517303s_nell
snugly1055663snugly
souari6311383souari
soul46435713sou__l
souls55127363sou_ls
sourball1045363sourball
sourly93612213sourly
spail74921553s_pail
spale74929213s_pale
spalls84217343s_palls
spell75020303s_pell
spill74821163s_pill
sprawl11188063sprawl
spurgall1143263spurgall
squabble2143883squabble
squabby2343283squabby
squalene1745613squalene
squalidly2242323squalidly
squallers1834683squallers
squallier1844363squallier
squalling1935173squalling
squallish2143403squallish
squalors1744583squalors
squamae1845723squamae
squared173610563squared
squarely2045353squarely
squarer163410663squarer
squares163714463squares
squarks20417183squarks
squashy2233843squashy
squatty1964823squatty
squawks23294883squawks
squeak1935253squeak
squeaks2034523squeaks
squeaky2343083squeaky
squealed1885353squealed
squealer17115603squealer
squeg1588033squ_eg
squegs1675643squegs
squelch2152953squelch
squib163710503squ_ib
squibs17317453squibs
squid154211903squ_id
squids16409803squids
squillae1745193squillae
squillas1745333squillas
squint154214793squint
squire155912463squire
squirm17387673squirm
squirt153812933squirt
squish1838573squish
squush1833993squush
stale55637103s_tale
stalk94518003s_talk
stalls64019933s_talls
steal56125473stea_l
steals64020063steals
still54922083s_till
stroll6311603stroll
studly10397693studly
stulls63912983stulls
suable83920553s_uable
suably112814533s_uably
suave83519873s_uave
sulk85326653s_u_lk
sully84622903s_ully
sulu45128423s_u_lu
sural55931263s_ural
surly85124433s_urly
swail86217163s_wail
swale85221593s_wale
swell84815983s_well
swill83417373s_will
tall47240213__tall
thrall93810293thrall
trull54012673tru_ll
usual5310183usua_l
usually1066063usually
usuals637783usuals
wall76236103__wall

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.1401276364.3
2DLD Change Limit1127162715.57620214.5
3Display Results2712710.0803387.5
 (SQL Overall)1786912715.79630830.1
 
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.