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

118 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
aquifer193488(None) 
aquifers2044391aquifers
aquiver1934751aquiver
acquirer1944092acquirer
quiver18278742_quiver
abider95314463a_bider
abuser85413683abu_ser
abutter957513abutter
achier113914263achi_er
acquire1835603acquire_
acquired2044043acquired
acquiree1944603acquiree
acquirers2043413acquirers
acquires1945403acquires
acquitter2043553acquitter
acrider1038623acrider
acuter84412863acu_ter
admirer1035513admirer
adviser11135783adviser
aerier64823153aeri_er
affixer2033913affixer
aider65431133a__ider
aimer75926823a__imer
airer54927893a__irer
airier64619363airi_er
aiver85725163a__iver
aliner65621983a_liner
amuser84712623amu_ser
antifur1047493antifur
aquae142212713aqu_ae_
aquafarm22122153aquafarm
aquiferous2252763aquiferous
arbiter939933arbiter
argufier1242113argufier
arider74717743a_rider
armiger1036253armiger
arriver10117793arriver
artier63419733arti_er
ashier94714833ashi_er
aspirer967903aspirer
asunder856223asunder
auger64922473a_u_ger
aulder7511453a_ulder
avoider1155813avoider
awaiter1057443awaiter
bluffer15396883bluffer
bruiser9349573bruiser
bruiter93710633bruiter
buffer144512683_buffer
chuffer18337143chuffer
conifer123212643conifer
crucifer1543683crucifer
cruiser93410433cruiser
duffer134711663_duffer
duiker114110593_duiker
equine151711573equine_
equines161811593equines
equipper2143053equipper
equites162212493equites
faquir1834313faqui__r
fifer115519973__fifer
fluffer12336503fluffer
fruiter10309683fruiter
gauffer1474423gauffer
gluier7310263glui_er
gruffer1475793gruffer
guider84313523_guider
heifer1238203_heifer
inquirer17235173inquirer
juicer1536283_juicer
knifer13598563_knifer
lifer85822153__lifer
lucifer1234603lucifer
puffer144610733_puffer
quaffer2235133_quaffer
quaker193811623_quaker
quaver18309313_quaver
queer143712813_qu_eer
queuer15357253_queuer
quicker2247023_quicker
quiet144530733_qui_et
quieter162810333_quieter
quiff201111553_quif_f
quiffs21135433_quiffs
quilter16279803_quilter
quipper2095813_quipper
quire144917123_quire_
quired163711943_quired
quires154015733_quires
quite144621463_quite_
quitter162910753_quitter
quivers19298753_quivers
quivery22265453_quivery
quizzer2434393_quizzer
quoter153510093_quoter
requirer17156113requirer
requiter17168643requiter
rifer84721983__rifer
rotifer1036993rotifer
ruiner64013643_ruiner
scuffer15328883scuffer
snuffer13318843snuffer
squarer163410653squarer
squiffed2433723squiffed
squiffier2442843squiffier
squiffy2542563squiffy
squinter1747353squinter
squire155912453squire_
squired173710053squired
squires163812833squires
squirmer1934363squirmer
squirter1746513squirter
stuffer13349793stuffer
stuiver10447083stuiver
suffer124314513_suffer
suiter64121813_suiter
surfer93515883_surfer
thurifer1443273thurifer

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.1531167915.0
2DLD Change Limit1340271186.45620760.1
3Display Results1181180.0462565.2
 (SQL Overall)1786911186.65526850.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.