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

135 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
squatting193451(None) 
equating18310112equa_ting
quanting1849232_quanting
quitting18228832_quitting
scatting113311812s_catting
shutting12309692shu_tting
slatting94014232s_latting
smutting11278062smu_tting
spatting113111762s_patting
splatting1235982splatting
squadding2143232squadding
squalling1935172squalling
squaring18158632squa_ring
squashing2234702squashing
squattering2143802squattering
squattier1843712squattier
squattily2142652squattily
squawking2642432squawking
squinting1936222squinting
squirting1934792squirting
swatting12309592s_watting
abutting1137003abu_tting
acquitting2243653acquitting
aquatint1749433aqua_tint
aquatinting2152353aquatinting
batting104422273__batting
blatting114111653_blatting
butting103519283_bu_tting
catting103922643__catting
chatting142810143_chatting
coquetting2244513coquetting
cutting103817493_cu_tting
defatting1436103defatting
deratting1139513deratting
dratting10389663_dratting
duetting1047183_duetting
equaling1837793equa_ling
equalling1945243equalling
fatting113818703__fatting
flatting123511253_flatting
glutting10247643glu_tting
gutting93415923_gu_tting
hatting113920233__hatting
hutting113016033_hu_tting
jutting153313713_ju_tting
liquating1946313liqua_ting
matting103620143__matting
mutating112211753_mutating
nutating92411953_nutating
nutting83316233_nu_tting
patting103722343__patting
platting114813033_platting
putting103218573_pu_tting
quacking2436743_quacking
quadding2035363_quadding
quaffing2434353_quaffing
quailing1838403_quailing
quaking2139313_qua_king
quantong1843493_quantong
quashing2137093_quashing
questing1838273_questing
quieting18228463_quieting
quilting18218713_quilting
quirting18238383_quirting
quoiting1836093_quoiting
quoting17310043_qu_oting
ratting83822363__ratting
rutting82718043_ru_tting
salting84120793s__alting
sating74735453s__a_ting
sauteing937913sau_teing
scanting113914763s_canting
scarting113415263s_carting
scathing14269703s_cathing
sculpting1435003sculpting
scuttling1234243scuttling
seating84130683s_ea_ting
sedating103014113seda_ting
setting83621393s__etting
shafting15278683s_hafting
sheathing1636873sheathing
shitting123212663s_hitting
shotting123012383s_hotting
shunting123610433shu_nting
shuting113212053shu__ting
shuttling1334293shuttling
sinuating1039683sinua_ting
sitting83519633s__itting
situating1038883situa_ting
skating123613853s_ka_ting
slanting94115093s_lanting
slating83724653s_la_ting
slattings10346073s_lattings
slitting93012583s_litting
slotting92612613s_lotting
smarting113212453s_marting
solating9315593sola_ting
southing122811823sou_thing
spitting113012323s_pitting
splitting1236563splitting
spotting112812093s_potting
sprattling1363053sprattling
spurting113111633spu_rting
squabbling2442033squabbling
squatted1835343squatt_ed
squatter1735913squatt_er
squatters1834953squatters
squattest1844613squattest
squattiest1944243squattiest
squatty1964823squatt__y
squeaking2334213squeaking
squealing1935153squealing
squeezing2843083squeezing
squegging2162503squegging
squibbing2342753squibbing
squidding2143153squidding
squiring18177563squ_iring
squirming2143223squirming
squishing2234953squishing
squushing2242943squushing
starting93116173s_tarting
stating83725163s_ta_ting
stetting93410713s_tetting
stotting92811163s_totting
strutting1037003strutting
stunting92811503stu_nting
suiting83419003s_u_iting
swathing15248713s_wathing
sweating123213023swea_ting
swotting12268483s_wotting
tatting84019523__tatting
truanting1035603truanting
tutting83515913_tu_tting
unhatting1335873unhatting
vatting113614853__vatting

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 Filter1786911486410.403443402.0
2DLD Change Limit1486411357.05021083.8
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.49923828.6
 
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.