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

115 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
qualmier193456(None) 
balmier113811512_balmier
haulmier1333142haulmier
malmier113611952_malmier
palmier113312172_palmier
quackier23215372quackier
quaggier1933852quaggier
quagmire2042382quagmire
quakier20239202qua_kier
qualifier2145122qualifier
qualmiest2044392qualmiest
qualmish2244012qualmish
quarrier1736842quarrier
quartier1737542quartier
squallier1844362squallier
almner85710723__almner
balkier134111983_balkier
barmier114313043_barmier
baulkier1433533baulkier
beamier113411943bea_mier
bulgier103911213bu_lgier
bulkier134111513bu_lkier
bullier94116433bu_llier
burlier93514413burl_ier
calmer105216933_calm_er
chalkier1736753chalkier
clammier1435843clammier
coalier93416183coal_ier
curlier93314183curl_ier
dallier84215373_dallier
elmier839813__elmier
equaliser1854483equaliser
equalizer2745753equalizer
faultier1135283faultier
filmier1237503_filmier
flamier123112143fla_mier
foamier12339003foa_mier
fumier11310903fu__mier
gamier93617933_ga_mier
gammier123711193_gammier
guiltier934493guiltier
gulfier1137793gu_lfier
gulpier1046953gu_lpier
gummier12349473gu_mmier
hammier143510653_hammier
haulier1059943haul_ier
hulkier14328973hu_lkier
jammier18408023_jammier
loamier9349163loa_mier
maltier93015483_maltier
mealier93015903meal_ier
outlier72216143outl_ier
palier85023563_pal_ier
pallier94417163_pallier
palmer105816543_palm_er
pulpier1148623pu_lpier
quaffer2235133qua_ffer
quagmires2142303quagmires
quagmirier2251273quagmirier
quagmiry2341723quagmiry
quainter1765903quainter
quaker193811623qua__ker
quale143617853qual__e_
qualia1559563qual_i_a
qualified2245843qualified
qualifiers2243333qualifiers
qualifies2147503qualifies
qualify2235473qual_ify
qualities18311223qualities
quality1938563qual_ity
qualm163511183qualm___
qualms17317243qualm__s
qualmy20285803qualm__y
quantizer2743973quantizer
quarried1836093quarried
quarriers1845183quarriers
quarries1749943quarries
quarter163211853qua_rter
quartiers1845183quartiers
quasher19198623qua_sher
quaver18309313qua__ver
quaverer2054583quaverer
queasier1734473queasier
queazier2642833queazier
queller16289293quel_ler
querier16310013qu_erier
quilter16279803quil_ter
quippier2133773quippier
quirkier2134163quirkier
rallier73816273_rallier
rammier112811023_rammier
rulier65016353ru_l_ier
rummier11309563ru_mmier
sallier73320423_sallier
saltier74318633_saltier
scalier94316913scal_ier
seamier93114633sea_mier
shalier103116423shal_ier
smarmier1235033smarmier
squabbier2242753squabbier
squalider1943843squalider
squaller1736083squal_ler
squashier2143913squashier
squattier1843713squattier
squirmier2042853squirmier
stalkier1257073stalkier
sublimer1237613sublimer
sulkier113811963su_lkier
surlier72915443surl_ier
talkier114011843_talkier
tallier72817213_tallier
uglier748953_ugl_ier
vaultier1144293vaultier
vealier102712173veal_ier
yummier14306843yu_mmier

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.1561145455.1
2DLD Change Limit1461621157.00020880.3
3Display Results1151150.0303833.3
 (SQL Overall)1786911157.18624866.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.