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

92 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
overtrain125978(None) 
overstrain1347041overstrain
overtrains13109501overtrains
overdrawn1644672overdrawn
overlain112112442over_lain
overran10311662over_ra_n
overstrains1447162overstrains
overthin1438532overt_hin
overtrade1348512overtrade
overtrading1648262overtrading
overtrained1547102overtrained
overtrim1337482overtr_im
certain92612213_cert_ain
detrain8412253_de_train
entrain7313073__entrain
eyestrain1243433eyestrain
oestrin7312243o_estr_in
overarming1639233overarming
overbrake1847253overbrake
overbraking2147143overbraking
overclaim1645333overclaim
overcram1537073overcra_m
overcrams1646413overcrams
overdaring1539503overdaring
overdraft1646713overdraft
overdrank1745123overdrank
overdraw1535803overdra_w
overdrawing1956683overdrawing
overdraws1645663overdraws
overdrink1746273overdr_ink
overdrying1846543overdrying
overfrank1944573overfrank
overgrade1457623overgrade
overgrading1747513overgrading
overgraze2276673overgraze
overgrazing2566773overgrazing
overgrown1644283overgrown
overlaid122410383over_laid
overlearn1235903overlearn
overman12311463over_ma_n
overpaid14158933over_paid
overplaid1546813overplaid
overplan13258943overpla_n
overpraise1547423overpraise
overprint14412253overpr_int
overrank1548113over_rank
overrash1436953over_rash
overrate11615693over_rate
overrating14814203over_rating
overrun1038023over_r_un
overspin1338203over_spin
overstrained1645273overstrained
overstrewn1643463overstrewn
overtake151210143overt_ake
overtaken16126633overtaken
overtaking1878893overtaking
overtalk1537073overt_alk
overtame131510523overt_ame
overtart11312493overt_art
overtask1535773overt_ask
overtax17257733overt_a_x
overtaxing2157693overtaxing
overteach1745003overteach
overthink1945843overt_hink
overthrown1942583overthrown
overtimid15145143overtimid
overtiming1699073overtiming
overtip1238193overt__ip
overtiring141210203overtiring
overtoil1137453overt_oil
overtraded1557073overtraded
overtrades1457493overtrades
overtraining1646023overtraining
overtreat1249373overtreat
overtreating1648553overtreating
overtreats1346643overtreats
overtrick1865833overtrick
overtrims1447503overtrims
overtrump1643563overtrump
overturing1499413overturing
overturn11157303overt_urn
overturning1545973overturning
overurging1547113overurging
pertain92714963_pert_ain
pretrain10310923pre_train
restrain8311703_restrain
retrain7615423_re_train
seatrain847923_seatrain
terrain7410853_ter_rain
veratrin1147703_veratr_in
vervain1335563_ver_vain
vitrain1038943_v_itrain

Search took 9 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.750238254.7
2DLD Change Limit148641927.26620457.1
3Display Results92920.0303066.7
 (SQL Overall)178691928.04622208.7
 
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.