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

90 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
aquifers204439(None) 
aquifer1934881aquifer_
acquirers2043412acquirers
aquiferous2252762aquiferous
aquiver1934752aquiver_
quivers19298752_quivers
abiders104011083a_biders
abusers94710553abu_sers
abutters1056993abutters
acquirees2043103acquirees
acquirer1944093acquirer_
acquires1945403acquire_s
acquitters2142953acquitters
admirers1134713admirers
advisers12135003advisers
affixers2143293affixers
aiders74524633a__iders
aimers84621913a__imers
airers64922313a__irers
aivers94822323a__ivers
aliners74717723a_liners
amusers94610193amu_sers
aquafarm22122153aquafarm
aquafarms23121443aquafarms
arbiters1038853arbiters
argufiers1341613argufiers
armigers1135703armigers
arrivers11137003arrivers
aspirers1066493aspirers
augers73818703a_u_gers
avoiders1254793avoiders
awaiters1146643awaiters
bluffers16405703bluffers
bruisers10307953bruisers
bruiters10329143bruiters
buffers153310793_buffers
conifers133611703conifers
crucifers1643333crucifers
cruisers10438273cruisers
duffers143410093_duffers
duikers12369383_duikers
equines161811593equine_s
equippers2242903equippers
equites162212493equite_s
faquirs1943863faqui__rs
fifers125414923__fifers
fluffers13335293fluffers
fruiters11328183fruiters
gauffers1563833gauffers
guiders94111113_guiders
heifers1337933_heifers
inquirers18234013inquirers
juicers1636153_juicers
knifers14537083_knifers
lifers95617843__lifers
lucifers1334163lucifers
puffers15349203_puffers
quaffers2333963_quaffers
quakers20309693_quakers
quavers19309013_quavers
queers153510773_qu_eers
queuers16366393_queuers
quieters17248733_quieters
quiets154014373_qui_ets
quiffs21135433_quif_fs
quilters17228433_quilters
quippers2184813_quippers
quires154015753_quire_s
quitters17238523_quitters
quiver18278743_quiver_
quivery22265463_quivery
quizzers2542943_quizzers
quoters16369263_quoters
requirers18165003requirers
requiters18176553requiters
rotifers1136043rotifers
ruiners74213023_ruiners
scuffers16307493scuffers
snuffers14326923snuffers
squarers17338023squarers
squinters1835523squinters
squires163812843squire_s
squirmers2053113squirmers
squirters1835073squirters
stuffers14277383stuffers
stuivers11406673stuivers
suffers133113543_suffers
suiters73618883_suiters
surfers103614133_surfers
thurifers1542913thurifers

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.406440125.6
2DLD Change Limit146162907.25020160.3
3Display Results90900.0332727.3
 (SQL Overall)178691907.68923239.8
 
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.