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

68 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
jetty15621258(None) 
jotty155012601jotty
jutty154914641jutty
netty85816761netty
petty105320291petty
batty105422242batty
betta74916842betta
bitty106119172bitty
butty104020112butty
catty104520412catty
cutty105417222cutty
deity94316772deity
ditty95019292ditty
dotty94516102dotty
fatty115117412fatty
fretty1249222fretty
gutty94516992gutty
hefty146112132hefty
janty156816962janty
jelly154218252jelly
jemmy19498552jemmy
jenny153811622jenny
jerky196712422jerky
jerry155016182jerry
jest116738502jest_
jests125922452jests
jet106754822je_t_
jete115927252je_te
jetes124922842jetes
jeton124815402jeton
jets115834102je_ts
jetted143915082jetted
jetton1338032jetton
jetway19105272jetway
jolty155713032jolty
kitty124614572kitty
lefty115613562lefty
meaty107021312meaty
melty104918362melty
natty85719142natty
nett46643232nett_
nettly9459452nettly
netts55320722netts
nitty85418312nitty
nutty84816872nutty
patty104723612patty
peaty105725692peaty
pesty106421712pesty
petti75119452petti
petto76021042petto
potty105621002potty
pretty11510872pretty
putty104721402putty
ratty84819592ratty
retry84718082retry
rutty85617802rutty
sett45949052sett_
setts55124322setts
tatty84720182tatty
tenty86121602tenty
testy85419062testy
titty85316652titty
tutty85217022tutty
wetly114511712wetly
witty114717012witty
yett76434492yett_
yetts86715132yetts
zesty176512162zesty

Search took 5 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 Filter178691538000.780229091.0
2DLD Change Limit53800683.04617662.5
3Display Results68680.0302266.7
 (SQL Overall)178691683.85646341.0
 
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.