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

73 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
quaintly206502(None) 
faintly1337082_faintly
quaint15415172quaint__
quainter1765902quainter
quakingly2644222quakingly
quietly1945892qu_ietly
saintly1039342_saintly
auntly95211063__auntly
brainily1337313brainily
daintily1245523_daintily
dainty105311473_daint_y
equinely2044643equ_inely
fumingly1735743fumingly
gainly1049323_gain_ly
gauntly1135333_gauntly
jointly1735483_jointly
lucently1344973lucently
luringly1237323luringly
mainly11411493_main_ly
musingly1436433musingly
painty114714753_paint_y
piquantly2343123piqua_ntly
plainly1236473plain_ly
pliantly1345783pliantly
pulingly1436803pulingly
quail144314363quai__l_
quails153412643quai__ls
quaintest1845343quaintest
quakily2336693qua_kily
quality1938563qualit_y
quant143624813qua_nt__
quanta153911333qua_nt_a
quantal16367893qua_ntal
quantally2144053qua_ntally
quanted1738963qua_nted
quantic18279063qua_ntic
quantify2343863qua_ntify
quantile1747323qua_ntile
quantity2044733qua_ntity
quants153614143qua_nt_s
quantum1845103qua_ntum
queenly1944463queen_ly
quickly2534073qu_ickly
quinary1936933qu_inary
quinela1635213qu_inela
quinol15357973qu_inol_
quinols16297243qu_inols
quinsy18386353qu_in_sy
quint144529903qu_int__
quinta153312373qu_int_a
quintal16389883qu_intal
quintals17288003qu_intals
quintan16399223qu_intan
quintar16478603qu_intar
quintas163611713qu_intas
quinte153414523qu_int_e
quintes164114713qu_intes
quintet163914453qu_intet
quintic18308883qu_intic
quintile1736843qu_intile
quintin163810333qu_intin
quints154316563qu_int_s
quintuply23172193qu_intuply
rainily10310433_rainily
riantly1037613ria_ntly
scantly12419553sca_ntly
slantly10399323sla_ntly
squatly1946433squa__tly
squinty19287063squ_int_y
supinely1376293supinely
truantly1144643trua_ntly
unsaintly1244993unsaintly
vainly1258503_vain_ly

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.780229091.0
2DLD Change Limit146162736.55022314.8
3Display Results73730.0302433.3
 (SQL Overall)178691737.36024278.7
 
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.