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

119 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
verier9462096(None) 
aerier64823161aerier
eerier64320021eerier
varier94619351varier
verger104315701verger
vernier102711271vernier
verser94516961verser
aerie54634602aerie_
aeried74221872aeried
aeries64737782aeries
airier64619362airier
averter102410552averter
beerier93613032beerier
belier84423562belier
brier74527402_brier
burier84324652burier
crier74724462_crier
decrier102713562decrier
defier105118652defier
denier74420692denier
derider93214972derider
deriver114213912deriver
dernier83011942dernier
dewier104013462dewier
drier64423962_drier
eelier64216462eelier
eerie55228532eerie_
fernier103110822fernier
fierier103511192fierier
frier85225842_frier
germier10309542germier
gorier73719372gorier
herbier1239592herbier
herder104516462herder
jerker17369042jerker
jerkier18407272jerkier
learier73415662learier
leerier73111502leerier
levier94013872levier
mercer105214202mercer
merer75126232mer_er
merger95016482merger
merrier92612302merrier
metier83517692metier
mirier83918362mirier
nerdier83110362nerdier
nervier10298842nervier
onerier7311612onerier
perkier133813122perkier
perter84422282perter
prier75027762_prier
querier16310012querier
relier65826182relier
serer55935512ser_er
serger73819742serger
series64540972series
server94917712server
sexier13310682sexier
sprier84119062sprier
tearier73815612tearier
termer85717252termer
terrier73414962terrier
terser67317822terser
trier54328532_trier
varied104817862varied
variers103712662variers
varies94330872varies
vealer94016542vealer
vealier102712172vealier
veer76229572ve__er
veeries102916892veeries
vegie94614512vegie_
vegies104314272vegies
veiler93814352veiler
veiner94514752veiner
veinier10269582veinier
veliger1137312veliger
vender103418422vender
veneer94511692veneer
venire93513692venire
venter94218722venter
verditer1236222verditer
verge93419842verge_
verged114815162verged
vergers114412632vergers
verges104320182verges
veriest103719132veriest
verifier14159202verifier
verify153110162verify
verily122616052verily
verism113214262verism
verist93823892verist
verite94323442verite
verites103822262verites
verity123714852verity
vermes115019142vermes
verniers11227842verniers
verse84723582verse_
versed104515522versed
versers103813522versers
verses94223762verses
verset94327322verset
vertex1637372vertex
verve115417722verve_
verves124617882verves
vervet124619062vervet
vesper1138082vesper
vetiver1336102vetiver
vetoer93410062vetoer
vetter93417642vetter
vexer155513522ve_xer
vier75428162v__ier
viewier1334982viewier
vinier93716742vinier
vizier184311022vizier
warier93722892warier
wearier103613292wearier
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 Limit825511192.43633887.9
3Display Results1191190.0333606.1
 (SQL Overall)1786911192.81263545.9
 
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.