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

89 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
overtreat124937(None) 
overgreat1347711overgreat
overtreats1346641overtreats
overbeat132713832over_beat
overeat102620322ove__reat
overheat142413772over_heat
overneat112713642over_neat
overreact1448402over_react
overtreated1547412overtreated
entreat7315263__entreat
estreat7314813__estreat
overalert12411113overalert
overbear13228883over_bear
overbeats14279823over_beats
overbet122716063over_be_t
overbred1459853overbre_d
overbreed1548043overbreed
overbroad1545433overbroad
overcheap1953513overcheap
overclean14115263overclean
overclear14134743overclear
overcoat13312103over_coat
overcram1537073overcr_am
overdear12248083over_dear
overdirect1644513overdirect
overdraft1646713overdraft
overdraw1535803overdr_aw
overdress1346593overdress
overdrew1536233overdre_w
overeats112415263ove__reats
overexert1947843overexert
overfat132712283ove__rfat
overfear14247403over_fear
overfree1439003overfre_e
overgrew1535823overgre_w
overhead152110363over_head
overheap16257343over_heap
overhear14249413over_hear
overheats15229993over_heats
overleaf14237973over_leaf
overleap13237833over_leap
overleapt14247883over_leapt
overlent112715293over_lent
overlet102619033over_le_t
overmelt13310713over_melt
overnear11238473over_near
overpert13312993over_pert
overprint14412253overprint
overran10311663over_r_an
overrate11615693over_r_ate
overreach1745503over_reach
overreacts1545433over_reacts
overroast1247873over_roast
oversea102412113over_sea_
overseas112612423over_seas
overset102821473over_se_t
overslept1446853overslept
overspent1449923overspent
overspread1643563overspread
overstress1345763overstress
overstrew1546483overstre_w
overstrewn1643463overstrewn
overstrews1644473overstrews
oversweet1548903oversweet
overtart11312493overt_art
overtax17257733overt__ax
overteach1745003overt_each
overthrew1844233overthre_w
overtight1647613overtight
overtire111413113overtire__
overtired131310253overtire_d
overtires121412373overtire_s
overtness1238223overtness
overtrade1348513overtrade
overtrain1259783overtrain
overtreating1648553overtreating
overtrick1865833overtrick
overtrim1337483overtr_im
overtrims1447503overtrims
overtrump1643563overtrump
overture111511683overture__
overtured13169213overture_d
overtures121611453overture_s
overweak18216073over_weak
overwear14248603over_wear
overwet132013933over_we_t
overzeal2076093over_zeal
pretreat10311923pre_treat
retreat7317533_re_treat

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.1561145455.1
2DLD Change Limit148641897.01621186.0
3Display Results89890.0461934.8
 (SQL Overall)178691897.21824756.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.