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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
pretreatments175249(None) 
pretreatment1653271pretreatment_
entreatments14114393_entreatments
maltreatments1761493maltreatments
mistreatments1762773mistreatments
nontreatments1563293nontreatments
overtreatments1962793overtreatments
presentments1654303pre_sentments
retreatants1152553_retreat_ants
treatments1246283___treatments
arrestments1354694ar__restments
entreatment13115644_entreatment_
maltreatment1662014maltreatment_
mistreatment1653444mistreatment_
nontreatment1454134nontreatment_
overtreatment1863764overtreatment_
posttreatment1761424posttreatment_
predicaments1953224predica_ments
preferments1844744pre_fe_rments
preordainments1981514preordainments
prepayments2053334pre__payments
presentiments1753024pre_sentiments
presentment1555674pre_sentment_
pretreated1347624pretreat_e__d
pretreating1448894pretreat_in_g
pretreats1146934pretrea____ts
rearmaments1554264_rearma_ments
recrements1449354_recre__ments
recruitments16113394_recruitments
refreshments2053604_refreshments
resentments1346544_re_sentments
retirements1357614_retire__ments
retreatant1054944_retreat_ant_
retreaters1047544_retreat_e_rs
retrenchments2062574_retrenchments
revealments1644494_re_vealments
revetments1546434_re_ve_tments
treatment1148184___treatment_
arbitraments16152615arbitr_a_ments
arrestment1246255ar__restment_
bereavements19154205_be_reavements
besetments1445295_be_se_tments
betterments1544715_bette_rments
cerements13411455_ce_re__ments
contentments1655485cont_entments
curettements1652485curette__ments
decrements1549385_decre__ments
determents131010315_det_e_rments
detrainments1574655_detrainments
detriments1347365_detr__iments
ejectments2144055__e_jectments
endearments14115385__endearments
entrapments1546295_entr_apments
entrustments1453805_entrustments
overgarments18133675ove_rgarments
overpayments2253495ove_rpayments
paraments13511555p__ar_a_ments
permanents1455455p_e_rma_nents
preachments2044235pre__achments
prearrangements2071705prearrangements
precedents1545725pre_ce__dents
precommitments2161615precommitments
precreases1445655precrea_se__s
predicament1854755predica_ment_
preferment1746325pre_fe_rment_
preheaters1557195pre_heat_e_rs
prejudgments2551845pre_judgments
preordainment1881875preordainment_
prepayment1944605pre__payment_
presentient1348325pre_sentient_
presentiment1654455pre_sentiment_
presweetens1651985presweet_en_s
preteens1038125pret_e___en_s
preterites12411795preterit_e__s
pretermits1445035pret_e_rm_its
pretheater1545545pretheat_e__r
pretournament1761465pretourna_ment_
pretrains11410145pretr_a__in_s
pretreat10311925pretrea____t_
prevalents1594975pre__va_lents
procreates1448155procreat_e__s
procreations1647275procreation_s
procurements1852915procure__ments
protectants1554365prot_ect_ants
protestants1354555prot_est_ants
rearguments1483845_rear_guments
rearmament1455385_rearma_ment_
recements13312285_re_ce__ments
recreants1146625_recrea___nts
recreates11313365_recreat_e__s
recreations13412255_recreation_s
recrement13411365_recre__ment_
recruitment15113785_recruitment_
reenactments1653185_reenactments
refrainments1754005_refrainments
refreshment1954065_refreshment_
reinvestments1853105_reinvestments
remitments1446845_re__mitments
repayments1744905_re__payments
represents1246755_repre__sents
resentment1248085_re_sentment_
ressentiments1582845_ressentiments
restatements1455285_re_statements
retirement1259125_retire__ment_
retreated10312625_retreat_e__d
retreater9310205_retreat_e__r
retreating111414775_retreat_in_g
retreats8311415_retrea____ts
retrenchment1953235_retrenchment_
revealment1545545_re_vealment_
revelments1546865_re_ve_lments
revetment1448325_re_ve_tment_
strewments1544185__stre_wments

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.393454684.5
2DLD Change Limit1247901139.37613309.5
3Display Results1131130.0761486.8
 (SQL Overall)1786911139.84518150.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.