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

88 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
overtrading164826(None) 
overgrading1747511overgrading
overbraking2147142overbraking
overdrawing1956682overdrawing
overgoading1746562overgoading
overgrazing2566772overgrazing
overlading1539322over_lading
overloading1647332overloading
overrating14814202over_rating
overriding1548512over_riding
overshading1946642overshading
overstriding1745612overstriding
overtaking1878892overt_aking
overtaxing2157692overt_axing
overtrain1259782overtra_in_
overtraining1646022overtraining
overtrains13109502overtra_ins
overtreating1648552overtreating
outtrading1247153o_uttrading
overarching2056893overarching
overarming1639233overar_ming
overawing16710293ove__rawing
overbaking2067773over_baking
overbearing1748423overbearing
overbeating17410483overbeating
overbidding1944723overbidding
overbreeding1944443overbreeding
overcramming2244593overcramming
overcrowding2243973overcrowding
overdaring1539503over_daring
overdriving1946093overdriving
overdrying1846543overdr_ying
overeating141016533over_eating
overfearing1847553overfearing
overfeeding1945913overfeeding
overfunding1945383overfunding
overgilding1795203overgilding
overgirding17105643overgirding
overglazing2545973overglazing
overgrowing1945703overgrowing
overhanding1947023overhanding
overhating17910953over_hating
overheaping2046793overheaping
overhearing1847843overhearing
overheating1849933overheating
overholding1955643overholding
overlaying1738443over_laying
overleaping1747443overleaping
overlending1647613overlending
overlording1647463overlording
overpaying1937953over_paying
overplaying2047343overplaying
overpraising1846133overpraising
overpricing1947733overpricing
overprizing2648033overprizing
overruling1467613over_ruling
oversaving1738163over_saving
overseeding1647003overseeding
oversoaking1956783oversoaking
overspreading2053603overspreading
overstating15410733overstating
overstaying1847053overstaying
overstrain1347043overstra_in_
overstraining1754133overstraining
overstrains1447163overstra_ins
overstrewing1944673overstrewing
overtalking1976693overtalking
overtasking1986153overtasking
overteaching2174923overteaching
overthrowing2243183overthrowing
overtiming1699073overt_iming
overtipping1945233overtipping
overtiring141210203overt_iring
overtoiling1547193overtoiling
overtopping1945653overtopping
overtrade1348513overtrad__e
overtraded1557073overtrad_ed
overtrades1457493overtrad_es
overtrained1547103overtra_ined
overtrimming2053743overtrimming
overtrumping2053333overtrumping
overturing1499413overt_uring
overturning1545973overturning
overurging1547113overur_ging
overwarming2046303overwarming
overwearing1847713overwearing
overwinding1955753overwinding
overwriting1847903overwriting

Search took 6 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 Filter1786911216330.1431249587.4
2DLD Change Limit121633885.39022566.4
3Display Results88880.0461913.0
 (SQL Overall)178691885.57932029.2
 
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.