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

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

45 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
pretreatment165327(None) 
pretreatments1752491pretreatments
entreatment13115643_entreatment
maltreatment1662013maltreatment
mistreatment1653443mistreatment
nontreatment1454133nontreatment
overtreatment1863763overtreatment
posttreatment1761423posttreatment
presentment1555673pre_sentment
pretreated1347623pretreat_e_d
pretreating1448893pretreat_ing
retreatant1054943_retreat_ant
treatment1148183___treatment
arrestment1246254ar__restment
entreatments14114394_entreatments
maltreatments1761494maltreatments
mistreatments1762774mistreatments
nontreatments1563294nontreatments
overtreatments1962794overtreatments
predicament1854754predica_ment
preferment1746324pre_fe_rment
preordainment1881874preordainment
prepayment1944604pre__payment
presentient1348324pre_sentient
presentiment1654454pre_sentiment
presentments1654304pre_sentments
pretheater1545544pretheat_e_r
pretournament1761464pretourna_ment
pretreat10311924pretrea____t
pretreats1146934pretreat___s
rearmament1455384_rearma_ment
recrement13411364_recre__ment
recruitment15113784_recruitment
refreshment1954064_refreshment
resentment1248084_re_sentment
retirement1259124_retire__ment
retreatants1152554_retreat_ants
retreated10312624_retreat_e_d
retreater9310204_retreat_e_r
retreaters1047544_retreat_ers
retreating111414774_retreat_ing
retrenchment1953234_retrenchment
revealment1545544_re_vealment
revetment1448324_re_ve_tment
treatments1246284___treatments

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 Filter1786911247900.393454684.5
2DLD Change Limit124790456.68618664.4
3Display Results45450.0301500.0
 (SQL Overall)178691457.10925135.9
 
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.