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

104 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
verbify183499(None) 
verify153110161ver_ify
versify1636331versify
aerify122810112aer_ify
certify1546242certify
terrify1336352terrify
verbid122311312verbi_d
verbids13259202verbids
verbile1249862verbile
verily122616052ver_ily
verity123714852ver_ity
acerbity1544273acerbity
aerily93017013aer_ily
beatify1536593beatify
carnify1555883carnify
cornify1536253cornify
deify124112763de__ify
densify1435293densify
derbies103016053derbies
derby114715343derb__y
diversify1943453diversify
edify12308563_e_dify
eerily92913563eer_ily
erbium1038083_erbium
ferity122813343fer_ity
fortify1636523fortify
gerbil938343gerbi_l
gerbils1037303gerbils
herbier1239593herbier
herby134715313herb__y
horrify1635023horrify
jellify2054543jellify
jerkily2134623jerkily
kerbing14308483kerbing
merrily1238633merrily
metrify1535623metrify
mortify1536223mortify
nervily1336863nervily
overbid132710273overbi_d
overbids14248903overbids
overbig13237543overbi_g
overbill1337283overbill
overbite13312083overbite
overbusy1654013overbusy
overbuy1545423overb_uy
overrife14169933overrife
overwily1736663overwily
perfidy1635273perfidy
perkily1637813perkily
petrify1536573petrify
purify14399153pur_ify
rarify123210063rar_ify
rectify1536453rectify
reedify1465763reedify
reify114814973__reify
reunify1344453reunify
reverify1744813rever_ify
serif84132133ser_if_
serifs94017053ser_ifs
terbia8311153terbi_a
terbias9310743terbias
terbic10410963terbi_c
terbium1147293terbium
testify13246943testify
torrify1335013torrify
varsity1356673varsity
veiny115414363ve__iny
veracity1647553veracity
verb96224873verb___
verbal112513663verb_al
verbally1647183verbally
verbals121910743verbals
verbena1235373verbena
verbiage1444553verbiage
verbified18146013verbified
verbifies17157133verbifies
verbifying2244353verbifying
verbiles1338923verbiles
verbose1237753verbose
verbosity1744063verbosity
verbs104614393verb__s
verdict1339583verdict
verdin103113023verdi_n
verdins112812333verdins
verging123812303verging
verier94620963ver_ier
verism113214263ver_ism
verist93823893ver_ist
verite94323443ver_ite
vermian12329713vermian
vermin113414523vermi_n
vermis114214963vermi_s
vernier102711273vernier
vernix1636633verni_x
versine102515173versine
versing112314193versing
version10310923version
vertigo1146133vertigo
very108025643ver___y
vilify1536773v_ilify
vinify1536923v_inify
vitrify1645003vitrify
vivify1834703v_ivify
zombify2642253zombify

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.406440125.6
2DLD Change Limit1340271045.86022871.5
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.31228309.7
 
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.