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

146 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
verifier1415920(None) 
verified151510391verified
verifiers15166061verifiers
verifies141313481verifies
versifier15156531versifier
aerified121310132aerified
aerifies111313392aerifies
certifier1447352certifier
deifier113013122de_ifier
edifier11309262_edifier
petrifier1447122petrifier
purifier1338572purifier
reifier103414522re_ifier
terrifier12126602terrifier
veinier10269582ve_inier
verbified18146012verbified
verbifies17157132verbifies
verier94620962ver__ier
verities111418042verities
vernier102711272ver_nier
versified16147592versified
versifiers16154142versifiers
versifies15159332versifies
vilifier1456692vilifier
vivifier1745172vivifier
acetifier1444863acetifier
aerier64823153aer__ier
basifier1337313basifier
beefier12329093be_efier
brinier93613473_brinier
certified1548413certified
certifiers1545143certifiers
certifies14310323certifies
clarifier1446123clarifier
codifier1447163codifier
defier105118653de__fier
deified123112413de_ified
deifiers12348993de_ifiers
deifies113317453de_ifies
derider93214973deri_der
deringer1038143deringer
deriver114213913deri_ver
dernier83011943der_nier
diversifier1862673diversifier
drifter11348703_drifter
driftier1275123_driftier
edified12339713_edified
edifiers12336673_edifiers
edifies113012283_edifies
eerier64320023eer__ier
ferities111416713ferities
fernier103110823fer_nier
fortifier1546253fortifier
gasifier1236273gasifier
gentrifier1444813gentrifier
germier10309543ger_mier
glorifier1344233glorifier
grifter113810493_grifter
grimier103210433_grimier
gripier103210323_gripier
heifer1238203he_if_er
herbier1239593her_bier
jerkier18407273jer_kier
leafier10329833le_afier
merrier92612303mer_rier
metrified1547853metrified
metrifies1439803metrifies
modifier1446703modifier
mortifier1446923mortifier
nerdier83110353ner_dier
nervier10298833ner_vier
nitrifier1245963nitrifier
notifier1137423notifier
ossifier111196273ossifier
pacifier1557503pacifier
peripter1278753peripter
perkier133813123per_kier
petrified1548333petrified
petrifiers1544673petrifiers
petrifies14310363petrifies
pricier113313113_pricier
privier122910453_privier
purified1438743purified
purifiers1435873purifiers
purifies13311923purifies
rarefier1135353rarefier
rarified1239053rarified
rarifies11311933rarifies
ratifier1139673ratifier
rectifier1457733rectifier
reefier102912553re_efier
reified112913783re_ified
reifiers11309843re_ifiers
reifies104218283re_ifies
reverified1745123reverified
reverifies1645973reverifies
ribier84414233__ribier
rifer84721983__rif_er
rifler94014263__rifler
rimier83916273__rimier
scarifier1446653scarifier
scorifier1445413scorifier
serifed11811463serif_ed
seriffed1594973seriffed
specifier1645683specifier
stripier1058863stripier
surfier102613543sur_fier
terrier73414963ter_rier
terrified13147573terrified
terrifiers13144573terrifiers
terrifies12139723terrifies
testifier12116893testifier
thriftier1542853thriftier
trifler103912153_trifler
turfier10249793tur_fier
typifier1643403typifier
uglifier1244503uglifier
unifier102211863_unifier
varier94619353var__ier
vealier102712173ve_alier
veiler93814353ve_i_ler
veiner94514753ve_i_ner
veliger1137313veli_ger
verderer1245373verderer
verditer1236223verditer
verger104315703ver__ger
veridic1338143veridi_c
verify153110163verif__y
verifying1936413verifying
verite94323443veri_te_
verites103822263veri_tes
verniers11227843ver_niers
verser94516963ver__ser
vetiver1336103veti_ver
vilified1547243vilified
vilifiers1544563vilifiers
vilifies1439593vilifies
vinier93716743v__inier
vinified1537543vinified
vinifies1439873vinifies
vitrified1645983vitrified
vitrifies1547223vitrifies
vivified1845893vivified
vivifiers1843673vivifiers
vivifies1747023vivifies
vizier184311023v__izier

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.420425454.8
2DLD Change Limit1461621466.56322270.6
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.04625360.6
 
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.