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

65 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
nitrifier124596(None) 
nitrified1346721nitrified
nitrifiers1343921nitrifiers
nitrifies12107921nitrifies
denitrifier1553122denitrifier
nigrified1445322nigrified
nigrifies1346362nigrifies
notifier1137422not_ifier
petrifier1447122petrifier
vitrified1645982vitrified
vitrifies1547222vitrifies
certifier1447353certifier
citified1438253cit_ified
citifies13310683cit_ifies
clarifier1446123clarifier
denitrified1653783denitrified
denitrifiers1651913denitrifiers
denitrifies1544263denitrifies
fortifier1546253fortifier
gentrifier1444813gentrifier
glorifier1344233glorifier
intriguer1043873intriguer
introfied1345603introfied
introfies1247233introfies
lithified1644463lithified
lithifies1545503lithifies
metrified1547853metrified
metrifies1439803metrifies
micrified17126793micrified
micrifies16118673micrifies
mortifier1446923mortifier
nidified1346763ni_dified
nidifies1238233ni_difies
nitpicker1742203nitpicker
nitpickier1851213nitpickier
nitride82811243nitri_de_
nitrided10276753nitri_ded
nitrides92910703nitri_des
nitriding1146723nitriding
nitrify1335793nitrif__y
nitrifying1744783nitrifying
nitrile73011373nitri_le_
nitriles8269923nitri_les
nitrite72314463nitri_te_
nitrites82313453nitri_tes
nittier73512243nit__tier
notified1238363not_ified
notifiers1245023not_ifiers
notifies11310423not_ifies
nullifier1244333nullifier
petrified1548333petrified
petrifiers1544673petrifiers
petrifies14310363petrifies
purifier1338573_purifier
putrefier1443123putrefier
ratifier1139673rat_ifier
scarifier1446653scarifier
scorifier1445413scorifier
signifier1345713signifier
stripier1058863_stripier
terrifier12126603terrifier
trifler103912153__trifler
verifier14159203_verifier
vilifier1456693vi_lifier
vivifier1745173vi_vifier

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 Filter1786911486410.436409841.7
2DLD Change Limit148641656.73322076.5
3Display Results65650.0331969.7
 (SQL Overall)178691657.20224811.3
 
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.