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 “eerier” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
eerier6432002(None) 
aerier64823161aerier
beerier93613031beerier
eelier64216461eelier
eerie55228531eerie_
leerier73111501leerier
verier94620961verier
aerie54634602aerie_
aeried74221872aeried
aeries64737782aeries
airier64619362airier
beefier12329092beefier
belier84423562belier
brier74527402_brier
burier84324652burier
cheerier1348012cheerier
crier74724462_crier
decrier102713562decrier
deedier93011592deedier
defier105118652defier
denier74420692denier
derider93214972derider
deriver114213912deriver
dernier83011942dernier
dewier104013462dewier
drier64423962_drier
earlier72612752earlier
earner63617222earner
easier64218462easier
edgier8469732edgier
eeriest73620672eeriest
eerily92913562eerily
elmier839812elmier
emeries91620022emeries
envier939672envier
eyrie88117832eyrie_
eyries93816812eyries
eyrir8359652eyri_r
fernier103110822fernier
fierier103511192fierier
frier85225842_frier
geekier12286392geekier
germier10309542germier
gorier73719372gorier
herbier1239592herbier
herder104516462herder
jeerer13389932jeer_er
jerker17369042jerker
jerkier18407272jerkier
learier73415662learier
levier94013872levier
mercer105214202mercer
merer75126232mer_er
merger95016482merger
merrier92612302merrier
metier83517692metier
mirier83918362mirier
needier84010622needier
nerdier83110362nerdier
nervier10298842nervier
onerier7311612onerier
peerie83617892peerie_
peeries93623022peeries
perkier133813122perkier
perter84422282perter
prier75027762_prier
querier16310012querier
reedier83815302reedier
reefier102912552reefier
reekier113111122reekier
relier65826182relier
seedier83513632seedier
seepier92912012seepier
serer55935512ser_er
serger73819742serger
series64540972series
server94917712server
sexier13310682sexier
sneerier878102sneerier
sprier84119062sprier
tearier73815612tearier
teenier72611142teenier
termer85717252termer
terrier73414962terrier
terser67317822terser
trier54328532_trier
varier94619352varier
veeries102916892veeries
verger104315702verger
vernier102711272vernier
verser94516962verser
warier93722892warier
wearier103613292wearier
weedier113810622weedier
weenier103210802weenier
weepier12319272weepier
wirier94215552wirier
wrier84521752_wrier

Search took 3 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 Filter178691825510.373479064.3
2DLD Change Limit82551982.34335233.0
3Display Results98980.0332969.7
 (SQL Overall)178691982.74965002.2
 
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.