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

129 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
squirters183507(None) 
squinters1835521squinters
squirmers2053111squirmers
squirter1746521squirter_
quarters173110452_quarters
quieters17248732_quieters
quilters17228432_quilters
quitters17238522_quitters
skirters12337242s_kirters
spurters103311702spu_rters
squarers17338022squar_ers
squatters1834942squatters
squinter1747362squinter_
squireens1842732squireens
squires163812842squir_e_s
squirmer1934372squirmer_
squirrels18333422squirrels
squirted1845792squirte_d
squirts16348012squirt__s
suiters73618882s_ui_ters
acquirers2043413acquir_ers
acquitters2142953acquitters
aquifers2044393aqui_fers
blurters10348373blu_rters
bruiters10329143brui_ters
courters103015373cou_rters
equippers2242903equippers
equites162212493equi_te_s
esquires17266213esquir_e_s
flirters11337933_flirters
fruiters11328183frui_ters
hurters103413643_hu_rters
inquirers18234013inquir_ers
quarter163211853_quarter_
quartern17286473_quartern
quarterns18285153_quarterns
quartes163314933_quarte_s
quartets17277573_quartets
quartiers1845183_quartiers
queriers1736963_queriers
questers17168763_questers
quietens17246343_quietens
quieter162810333_quieter_
quilter16279803_quilter_
quintars17337563_quintars
quintes164114713_quinte_s
quintets17347203_quintets
quippers2184813_quippers
quipsters2043593_quipsters
quires154015753_quir_e_s
quirted17369213_quirte_d
quirts154213553_quirt__s
quitter162910753_quitter_
quittors17155413_quittors
quivers19298753_qui_vers
quizzers2542943_quizzers
quoters16369263_qu_oters
requirers18165003requir_ers
requiters18176553requi_ters
saunters82911753sau_nters
scripters13116683scripters
scutters103311023scu_tters
sequesters1943843sequesters
sequiturs1842753sequi_turs
shifters14319863s_hifters
shirkers15319583s_hirkers
shunters113210753shu_nters
shutters113611353shu_tters
sifters103714793s__ifters
sinters74024083s__inters
sisters73721593s__isters
sitters74221553s__itters
skirter11338483s_kirter_
skitters12349553s_kitters
slitters84014133s_litters
smirkers14316353s_mirkers
smiters93414363s_mi_ters
snifters11318613s_nifters
snorters83410583s_norters
sorters74221133s__orters
souters74422603sou__ters
spitters104113383s_pitters
splinters11277923splinters
splitters11307323splitters
sporters103714063s_porters
sprinters11329363sprinters
spurners10288493spu_rners
spurrers10338463spu_rrers
spurriers11245063spurriers
spurter94013003spu_rter_
sputters104012873spu_tters
squallers1834683squallers
squanders1934443squanders
squarer163410663squar_er_
squares163714463squar_e_s
squashers21184983squashers
squatter1735913squatter_
squawkers2542483squawkers
squeakers2284113squeakers
squealers1894453squealers
squeezers2742553squeezers
squilgees1942833squilgees
squinted1847063squinte_d
squintest1845703squintest
squintier1844473squintier_
squints16339033squint__s
squire155912463squir_e__
squired173710063squir_e_d
squireen1744393squir_een
squirmed2034173squirme_d
squirmier2042853squirmier_
squirms18376343squir__ms
squirrel17414533squirre_l
squirrely21283333squirrely
squirt153812933squirt___
squirting1934793squirting
squishes20198393squishe_s
starters83714773s_tarters
stinters83312753s_tinters
stirrers8266943s_tirrers
stuivers11406673stui_vers
stutters83210473stu_tters
suiter64121813s_ui_ter_
suites63727403s_ui_te_s
suitors73012493s_ui_tors
sumpters1238023s_umpters
surfers103614133s_u_rfers
surgers83517483s_u_rgers
swifters14277483s_wifters

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411296.17324079.2
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.63926915.3
 
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.