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

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

79 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
verbifies1715712(None) 
verbified18146011verbified
verifies141313481ver_ifies
versifies15159331versifies
aerifies111313392aer_ifies
certifies14310322certifies
terrifies12139702terrifies
verbiages1544672verbiages
verbicides18104372verbicides
verbiles1338912verbi_les
verified151510392ver_ified
verifier14159202ver_ifier
verifiers15166062ver_ifiers
verities111418042ver_ities
versified16147592versified
versifier15156532versifier
versifiers16154142versifiers
acerbities1444973acerbities
aerified121310133aer_ified
beatifies1459283beatifies
carnifies1439893carnifies
certified1548413certified
certifier1447353certifier
certifiers1545143certifiers
cornifies1438993cornifies
deifies113317453de__ifies
densifies1347993densifies
derbies103016053derb__ies
diversifies1853803diversifies
edifies113012283_e_difies
ferities111416713fer_ities
fortifies1548683fortifies
gerbilles1244013gerbilles
herbicides1884193herbicides
horrifies15146383horrifies
jellifies1946263jellifies
metrifies1439793metrifies
mortifies1439393mortifies
overbites14310973overbi_tes
perfidies1546603perfidies
petrifies14310353petrifies
purifies13311923pur_ifies
rarifies11311933rar_ifies
rectifies14310813rectifies
reedifies1347323reedifies
reifies104218283__reifies
reunifies1247583reunifies
reverifies1645973rever_ifies
terrified13147573terrified
terrifier12126593terrifier
terrifiers13144573terrifiers
testifies12139263testifies
torrifies12137023torrifies
varsities1239243varsities
veracities1549503veracities
verbalizes2448293verbalizes
verbiage1444543verbiage_
verbicide1784633verbicide
verbids13259203verb__ids
verbify1834993verbif__y
verbifying2244353verbifying
verbile1249863verbi_le_
verbosities1644893verbosities
verites103822253ver_i_tes
vermicides1894913vermicides
vermifuges1951743vermifuges
vernicles1446133vernicles
vernixes1836053verni_xes
versicles1446353versicles
versines112213823versi_nes
vertices13612273verti_ces
verticils1446183verticils
vertigines1445203vertigines
vertigoes1354693vertigoes
vilifies1439593v_ilifies
vinifies1439873v_inifies
vitrifies1547223vitrifies
vivifies1747023v_ivifies
zombifies2543213zombifies

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 Filter1786911486410.220812231.8
2DLD Change Limit148641796.37623312.6
3Display Results79790.0461717.4
 (SQL Overall)178691796.64226903.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.