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

112 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
qualify223547(None) 
quality1938561quality
coalify1536682coalify
duality1147972duality
equality2046992equality
nullify1334712nullify
quakily2336692quakily
qualia1559562quali_a
qualmy20285802qual_my
quantify2343862quantify
requalify2443072requalify
salify12311372_salify
uglify1333912_uglify
alif76242143__alif_
alifs86121263__alifs
alkalify1842823alkalify
amplify1744083amplify
anality10313633anality
aurality1139223aurality
basify1437513_basify
beatify1536593beatify
burlily1237713burlily
calcify1735873_calcify
calif104929103_calif_
califs114915893_califs
clarify1536093clarify
curlily1238383curlily
disqualify2651973disqualify
dualism1049163dualism
dualist8614053dualist
dualize1759763dualize
dually103210063dual_ly
dulcify1643023dulcify
equaling1837793equaling
equalise1748213equalise
equalize2648023equalize
equally1936873equal_ly
falsify1643613_falsify
gasify1336333_gasify
gratify1436113gratify
gulfy124612003gu_l_fy
jellify2054553jellify
jollify2044263jollify
justify2034663justify
kalif125021363_kalif_
kalifs134410983_kalifs
khalif1657833khalif_
khalifa1742883khalifa
khalifs1754073khalifs
mollify1555503mollify
mummify1643333mummify
nazify2134233_nazify
nullity1037363nullity
opacify1743653opacify
orality101111683orality
ovality1377593ovality
pacify1667473_pacify
prequalify2751943prequalify
purify14399153pu_rify
quacky24376963qua_cky
quaff201311353qua__ff
quaffs21125693qua_ffs
quaggy2084683qua_ggy
quagmiry2341723quagmiry
quai134420393qua_i__
quaich2047693qua_ich
quaigh1935463qua_igh
quail144314363qua_i_l
quailed1737823quailed
quailing1838403quailing
quails153412643qua_ils
quaint15415173qua_int
quais144618393qua_i_s
quakier20239203quakier
quaking2139313quaking
quaky214310743qua__ky
quale143617853qual__e
qualified2245843qualified
qualifier2145123qualifier
qualifies2147503qualifies
qualifying2643973qualifying
qualm163511183qual__m
qualmier1934563qualmier
qualmish2244013qualmish
qualms17317243qual_ms
quantity2044733quantity
quarry1837473qua_rry
quasi144015023quasi__
quavery22225483quavery
quay164618353qua___y
quaylike2434143quaylike
queasily2043693queasily
quiff201111563qu__iff
ramify14268753_ramify
rarify123210063_rarify
ratify122610043_ratify
reality10313573reality
rurality1137403rurality
russify1334063russify
salsify1334703_salsify
scarify1537443scarify
sealift10312793sealift
squalid1737053squali_d
squalidly2242323squalidly
squally1937673squal_ly
suavity1336323suavity
surlily10310003surlily
uglily1036193_uglily
unify113611113_u_nify
uplift114610653_uplift
vilify1536773_vilify
yuppify2042163yuppify

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.406440125.6
2DLD Change Limit1340271125.70323501.1
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.15529031.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.