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

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

74 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
deprogrammers216242(None) 
deprogrammer2062771deprogrammer_
deprogrammed2152632deprogramme_d
programmers1893532__programmers
aerogrammes1653773ae_rogramme_s
deprogramed1863213deprogra_me_d
deprogramming2262553deprogramming
deprograms1655463deprogra_m__s
nonprogrammers21131393nonprogrammers
programers1584403__progra_mers
programmer1794113__programmer_
programmes1784933__programme_s
reprogrammed2063013reprogramme_d
reprographers2154663reprographers
aerogramme1553554ae_rogramme__
demographers2154564de_mographers
deprogram1555914deprogra_m___
deprograming1963364deprogra_ming
monogrammers1652604_monogrammers
nonprogrammer20121734nonprogrammer_
petrographers2155074petrographers
preprogrammed2362014preprogramme_d
programer1475604__progra_mer_
programme1694784__programme__
programmed1883884__programme_d
reprogramed1763764reprogra_me_d
reprogramming2172924reprogramming
reprograms1556224reprogra_m__s
reprographer2056254reprographer_
unprogrammed2062014unprogramme_d
aerograms1248155ae_rogra_m__s
chirographers2494695chirographers
chorographers24106125chorographers
defoamers15285255de_fo__a_mers
deformers15266535de_fo_r__mers
degraders12245935de___gra_ders
demographer2046375de_mographer_
dendrograms1652625dendrogra_m__s
deplorers1245465deplo_r___ers
depolarizers2453205dep_olarizers
deporters1277795dep_o_r__ters
depravers1534685dep___ra_vers
derogates11310975de_rog_a_te_s
dewormers15255195de_wo_r__mers
discographers2253195discographers
engrammes1444515_e__ngramme_s
epigraphers1953405_ep_igraphers
geographers1854785ge__ographers
hydrographers2654165hydrographers
misprogrammed2061695misprogramme_d
monogrammer1553025_monogrammer_
nephograms1844495nephogra_m__s
overprogrammed2561855overprogramme_d
petrographer2057285petrographer_
preprogramed2062505preprogra_me_d
preprogramming2461845preprogramming
preprograms1864115preprogra_m__s
proclaimers1752205__proclaimers
programed1585895__progra_me_d
programings1753425__programings
programming1954205__programming
programmings2052545__programmings
programs1339785__progra_m__s
reproachers1883225repro__achers
reprogram1456615reprogra_m___
reprograming1863905reprogra_ming
reprogrammable2371465reprogrammable
reprographics2395175reprographics
reprographies2196095reprographies
retrogrades1354005retrogra_de_s
serigraphers1853575se_rigraphers
topographers2055075top_ographers
typographers2354075typ_ographers
yellowhammers267935yellowhammers

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790749.25013490.8
3Display Results74740.0461608.7
 (SQL Overall)178691749.68618448.4
 
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.