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

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

91 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
typing12411058(None) 
hyping15408481hyping
taping94222391taping
toping94122991toping
tying96019841ty_ing
tyning105510411tyning
tyring104613021tyring
amping114317572amping
aping87327232_aping
coping113927662coping
doping103919462doping
duping104113632duping
dyeing11428212dyeing
dying105316032dy_ing
dyking15458012dyking
eyeing10429362eyeing
eying96117922ey_ing
gaping105618922gaping
gybing13355932gybing
gypping16305842gypping
gyring113910362gyring
gyving14415712gyving
hoping123719742hoping
hying126514742hy_ing
hypoing1636502hypoing
imping114315352imping
japing165013572japing
loping93921412loping
lying95717452ly_ing
lysing104710442lysing
moping114017102moping
oping86322412_oping
ping75943602__ping
piping114017452piping
raping94829852raping
retyping14255612retyping
riping93821612riping
roping94023022roping
ryking14348112ryking
siping94220632siping
spying123913252spying
stoping103716622stoping
stying105414572sty_ing
styling112910652styling
taking114725952taking
taming94023432taming
tamping122815812tamping
tapping123317132tapping
taring73932282taring
tawing104521552tawing
taxing143816712taxing
teeing73916972teeing
temping122710692temping
tewing103914822tewing
thing96622982t_hing
tiding83520092tiding
tieing73518762tieing
tiling73426552tiling
timing93619302timing
ting56139922t__ing
tining74927542tining
tipping122814972tipping
tiring74023092tiring
toeing74418472toeing
toking114420722toking
toling73926122toling
toning74025792toning
topping123514622topping
toting74123792toting
towing103823192towing
toying105017302toying
truing73913932truing
trying104214072trying
tsking114210422tsking
tubing93813092tubing
tumping123114242tumping
tuning74016842tuning
tupping123411662tupping
tyin76424002ty_in_
typic124511962typi_c
typier1137332typier
typify1734522typify
typist1139822typist
tything14316572tything
umping114815332umping
upping114013702upping
urping93914052urping
vying125111812vy_ing
wiping123916712wiping
wyling13368552wyling
wyting13277242wyting

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551912.42034112.0
3Display Results91910.0165687.5
 (SQL Overall)178691912.79663909.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.