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

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

80 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
luftmenschen22172204(None) 
luftmensch206382luftmensch__
menschen1543704____menschen
mensches1536295____mensches
menshen1236805____mens_hen
defensemen1652726def__ensemen
entrenched1643636_entren_ched
entrenches1545216_entren_ches
flenched17267966__f_len_ched
flenches163410536__f_len_ches
frenched17299436__f_ren_ched
frenches163311636__f_ren_ches
freshen133010886__f_re_s_hen
gegenschein186876__gegenschein
intrenched1644156_intren_ched
intrenches1545816_intren_ches
latencies1147776l_at_en_cies
lengthen1243536l____engthen
lensmen937886l____ens_men
lifemanship2173166lifemans_hip
liftmen1234236liftm_____en
loftinesses1437926loftines_ses
lucence11148006lu__cen_c_e_
lucences12137316lu__cen_c_es
lucencies1345846lu__cen_cies
lumens85013976lu__mens____
luminesce1343486lu__minesc_e_
luminesced1552576lu__minesc_ed
luminescent1553376lu__minesc_ent
luminesces1443966lu__minesc_es
lunched133911826lu____n_ched
luncheon1344016lu____n_cheon
luncher123111416lu____n_cher
lunches124115446lu____n_ches
lustinesses11910426lustines_ses
mensch13387096____mensch__
menschy17354006____mensch_y
menshes12310446____mens_hes
outfence1356976ou_tfen_c_e_
outfenced1555096ou_tfen_c_ed
outfences1456466ou_tfen_c_es
outmarched1843586ou_tm_arched
outmarches1744126ou_tm_arches
outmatched1843486ou_tm_atched
outmatches1763746ou_tm_atches
outmuscle1342206ou_tm_uscle_
outmuscled1542266ou_tm_uscled
outmuscles1442236ou_tm_uscles
outpunched1842776ou_tpun_ched
outpunches1742826ou_tpun_ches
outreached1645006ou_tre_ached
outreaches1545356ou_tre_aches
putrescent1465216pu_tre_sc_ent
putrescine1453406pu_tre_scine
putsches1535316pu_t___sches
quenched2334106qu___en_ched
quencher2234126qu___en_cher
quenches2236016qu___en_ches
refreshen1585166ref_re_s_hen
restrengthen1661496restrengthen
retrenched1654396_retren_ched
retrenches1545906_retren_ches
rufescent1444866ruf__e_sc_ent
stenches132110296__st_en_ches
strengthen1452696__strengthen
tenches123515526___t_en_ches
trenched14289856___tren_ched
trencher13279316___tren_cher
trenches133512606___tren_ches
tumesce1144566tu__me_sc_e_
tumesced1343526tu__me_sc_ed
tumescent1345406tu__me_sc_ent
tumesces1244846tu__me_sc_es
turtlenecked19111166turtlenecked
unblenched1842566_unblen_ched
unclenched1843356_unclen_ched
unclenches1743796_unclen_ches
unmeshed1437006_u_nme_s_hed
unmeshes1346156_u_nme_s_hes
unteaches1446086_unt_e_aches

Search took 19 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 Filter1786911646070.190940478.9
2DLD Change Limit1646078018.1109089.3
3Display Results80800.0461739.1
 (SQL Overall)1786918018.3469740.1
 
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.