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

138 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
squalid173705(None) 
equaled17166922equaled
qualia1559562_qualia
sialid7314942s_ialid
squad155110792squa__d
squalider1943842squalider
squalidly2242322squalidly
squall1538002squal_l
squalled1835942squalled
squalls1647312squalls
squally1937672squally
squalor1644422squalor
squared173610562squared
squealed1885352squealed
squid154211902squ__id
aquaria1638043aquaria
aquatic1838113aquatic
aquavit1945203aquavit
equal1449823equal__
equaling1837793equaling
equalise1748213equalise
equalised1945473equalised
equality2046993equality
equalize2648023equalize
equalized2846863equalized
equalled1834863equalled
equally1936873equally
equals1538693equal_s
equated171910403equated
equid154610323equ__id
halid94424983__halid
iguanid944563iguanid
invalid1146393invalid
ozalid1696683_ozalid
pyralid1347983pyralid
qaid146023843_q_a_id
quad144618703_qua__d
quai134420393_qua_i_
quail144314363_qua_il
quailed1737823_quailed
quails153412643_quails
quais144618393_qua_is
quaked203910033_quaked
quale143617853_qual_e
qualify2235473_qualify
quality1938563_quality
qualm163511183_qual_m
qualms17317243_qualms
qualmy20285803_qualmy
quasi144015023_quasi_
quid144922353_qu__id
said55742113s__a_id
salad65321833s__alad
salic73424713s__alic
salpid9510883s__alpid
sapid84720933s__apid
sayid95516723s__ayid
scald84818123s_cal_d
scaled94822443s_caled
sculled102911693sculled
sealed74328363s_ealed
sepaled10510593sepaled
sepaloid1146763sepaloid
shaled105023953s_haled
shauled1148793shauled
shoaled113810973shoaled
sialic8313633s_ialic
sialids839723s_ialids
sialoid8310963s_ialoid
siganid947203siganid
skald104210173s_kal_d
skoaled12226063skoaled
skulled12317403skulled
slid55828983s___lid
solid65025083s__olid
souari6311383souari_
souaris7312333souaris
souled75419823sou_led
souslik1144153souslik
sparid94016933s_parid
squab163810733squa__b
squabbled2342563squabbled
squabby2343283squabby
squabs17429323squa_bs
squadded2033843squadded
squads164410293squa_ds
squalene1745613squalene
squalidest2043393squalidest
squaller1736083squaller
squallier1844363squallier
squalling1935173squalling
squallish2143403squallish
squalors1744583squalors
squama1736533squa_ma
squamae1845723squamae
square154513363squa_re
squarer163410663squarer
squares163714463squares
squaring18158633squaring
squarish2047323squarish
squark19438113squa_rk
squarks20417183squarks
squash1846833squa_sh
squashed21215983squashed
squashy2233843squashy
squat143720143squa__t
squatly1946433squatly
squats153712963squa_ts
squatted1835343squatted
squatty1964823squatty
squaw17368983squa__w
squawk22385373squa_wk
squawked2543013squawked
squawks23294883squawks
squaws18438783squa_ws
squeaked2283903squeaked
squeal1538023squeal__
squealer17115603squealer
squealing1935153squealing
squeals1636513squeal_s
squelch2152953squelch
squib163710503squ__ib
squids16409803squ__ids
squill1537233squil_l
squilla1635533squilla
squills1666313squills
squired173710063squired
staid66722083s_ta_id
staled74728103s_taled
stolid74213183s_tolid
stupid937593stu_pid
subacid1248473subacid
subarid10310653subarid
sulfid1039063s_ulfid
sullied83714483s_ullied
sunlit61516103s_unlit
suslik1036373s_uslik
valid94618393__valid

Search took 7 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.403443402.0
2DLD Change Limit1340271386.30021274.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.74926476.7
 
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.