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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
aerier6482315(None) 
aerie54634601aerie_
aeried74221861aeried
aeries64737781aeries
airier64619361airier
eerier64320021eerier
verier94620961verier
acerber1135242acerber
achier113914262achier
acrider1038622acrider
aerial64625712aerial
aeriest73924052aeriest
aerify122810112aerify
aerily93017012aerily
aether94213672aether
airer54927892air_er
alerter72111512alerter
amercer1146372amercer
angrier839022angrier
aperies9423202aperies
arider74717742a_rider
ariel55228972a_riel
armer76924442a_rmer
arriver10117792arriver
artier63419732artier
ashier94714832ashier
atelier7311622atelier
averter102410552averter
barrier94017732barrier
beerier93613022beerier
belier84423562belier
brier74527402_brier
burier84324652burier
carrier93619582carrier
crier74724462_crier
decrier102713552decrier
defier105118652defier
denier74420692denier
derider93214972derider
deriver114213912deriver
dernier83011942dernier
dewier104013462dewier
drier64423962_drier
earlier72612742earlier
earner63617222earner
easier64218462easier
eelier64216462eelier
eerie55228532eerie_
faerie93514682faerie_
faeries104118992faeries
farrier103514892farrier
fernier103110822fernier
fierier103511192fierier
frier85225842_frier
germier10309542germier
gorier73719372gorier
hairier103111052hairier
harrier104417752harrier
herbier1239592herbier
herder104516462herder
jerker17369042jerker
jerkier18407272jerkier
learier73415662learier
leerier73111502leerier
levier94013872levier
marrier93817522marrier
mercer105214202mercer
merer75126232mer_er
merger95016482merger
merrier92612302merrier
metier83517692metier
mirier83918362mirier
nerdier83110352nerdier
nervier10298832nervier
onerier7311612onerier
parrier93717652parrier
perkier133813122perkier
perter84422282perter
prier75027762_prier
querier16310012querier
relier65826182relier
serer55935512ser_er
serger73819742serger
series64540972series
server94917712server
sexier13310682sexier
sprier84119062sprier
tarrier74323172tarrier
tearier73815612tearier
termer85717252termer
terrier73414962terrier
terser67317822terser
trier54328532_trier
varier94619352varier
verger104315702verger
vernier102711272vernier
verser94516962verser
warier93722892warier
waterier11312082waterier
wearier103613282wearier
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.343520965.0
2DLD Change Limit825511022.34635188.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911022.71965719.4
 
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.