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

63 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
quackish265438(None) 
quackism2543511quackism
blackish1976712blackish
brackish1987612brackish
buckish18237882bu_ckish
puckish18237212pu_ckish
quackier23215372quackier
quackiest2435182quackiest
quacking2436742quacking
quackisms2642272quackisms
quacks214710102quack_s_
qualmish2244012qualmish
quirkish2442992quirkish
blackfish2343833blackfish
blockish19115793blockish
cockish1838503_cockish
crankish1736513crankish
darkish1537943_darkish
duncish1335793dunc_ish
duskish1535183du_skish
gawkish1835833_gawkish
hawkish2036553_hawkish
hickish1936473_hickish
jackfish2744123_jackfish
larkish1439083_larkish
mawkish1935823_mawkish
peakish16268873pea_kish
peckish18227293_peckish
prankish1737023prankish
punkish16257693pu_nkish
quack203812503quack___
quacked2336793quack_ed
quackery2633113quackery
quacky24376963quack__y
quaich2047693qua__ich
quaigh1935463qua__igh
quais144618393qua__is_
quakes194013343qua_kes_
quakier20239203qua_kier
quakiest2138583qua_kiest
quakily2336693qua_kily
quaking2139313qua_king
quamash2144293qua_mash
quarks193810913quark_s_
quash174512163qua___sh
queerish2045313queerish
quickest2345343quickest
quickie2235513quicki_e
quickies2336773quickies
quicks21389303quick_s_
quippish2442633quippish
rakish134313963_ra_kish
rankish14510383_rankish
sickish1638423_sickish
sparkish17276973sparkish
squallish2143403squallish
squarish2047323squa_rish
squawfish2742263squawfish
stockish17186043stockish
suckfish2043893su_ckfish
thickish2044603thickish
trickish1746793trickish
weakish17217173wea_kish

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 Filter1786911461620.423422437.4
2DLD Change Limit146162637.18620339.8
3Display Results63630.0302100.0
 (SQL Overall)178691637.63923391.9
 
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.