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 “squattered” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
squattered204325(None) 
quartered19155962_quartered
scattered12197352s_cattered
scuttered12166422scu_ttered
shattered13178202s_hattered
shuttered13156332shu_ttered
smattered12186782s_mattered
spattered12187642s_pattered
splattered13163942splattered
sputtered12166322spu_ttered
squandered2142712squandered
squatted1835342squatt__ed
squatter1735912squatter__
squatters1834942squatter_s
stuttered10145762stu_ttered
battered113315053__battered
betattered1343143betattered
blattered12198573_blattered
buttered112712623_bu_ttered
chattered15197993_chattered
clattered12178413_clattered
cluttered12185943clu_ttered
flattered13188633_flattered
fluttered13185943flu_ttered
guttered10259163_gu_ttered
mattered112412903__mattered
muttered112610793_mu_ttered
nattered92011623__nattered
pattered112714203__pattered
puttered112611143_pu_ttered
quarterer18145713_quarterer
quavered2144813_qua_vered
reuttered1036073reu_ttered
sauntered1036283sau_ntered
scatterer11186293s_catterer
sequestered2152043sequestered
shatterer12177203s_hatterer
skittered1434633s_kittered
slathered13148553s_lathered
smatterer11185813s_matterer
spluttered13153173spluttered
sputterer11165263spu_tterer
squanderer2052153squanderer
squared173610563squa___red
squattering2143803squattering
squattest1844613squatte_st
squattier1843713squatt_ier
stutterer9164913stu_tterer
tattered92011443__tattered
unuttered1065733unu_ttered
uttered82712433__u_ttered
yattered12239533__yattered

Search took 10 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 Filter1786911406030.420425454.8
2DLD Change Limit140603528.69016179.9
3Display Results52520.123422.8
 (SQL Overall)178691529.23319353.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.