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

60 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
jimpy19521082(None) 
gimpy135212231gimpy
jimmy19538501jimmy
jimp155618461jimp_
jimply20397481jimply
jumpy195712811jumpy
wimpy155911921wimpy
bumpy144715052bumpy
campy145116182campy
crimpy15489392crimpy
dimly114913482dimly
dimply14339742dimply
dippy135111542dippy
dumpy135414752dumpy
gimp96124042gimp_
gimps105915202gimps
hempy154912762hempy
hippy155112792hippy
humpy155115672humpy
immy114611832_immy
imp76626972_imp_
impi85415792_impi
imply124911842_imply
imps86221122_imps
jammy194810192jammy
jemmy19498552jemmy
jiffy21458312jiffy
jiggy17549142jiggy
jiminy1836272jiminy
jimper17389862jimper
jivey185111872jivey
jivy176213112ji_vy
jump156621722jump_
jumps165116492jumps
limby125714072limby
limey104721042limey
limp88432492limp_
limpa97014462limpa
limply133810032limply
limps95522672limps
limpsy13516842limpsy
limy95727712lim_y
lippy124511902lippy
lumpy126615912lumpy
nippy124911112nippy
pimp106024902pimp_
pimply15329212pimply
pimps114616982pimps
pipy115421512pi_py
rimy96621282rim_y
simp85228772simp_
simply133010522simply
simps94719762simps
skimpy17475722skimpy
tippy125411792tippy
vampy15539402vampy
wimp115521522wimp_
wimps125213802wimps
wispy137210972wispy
zippy21518742zippy

Search took 2 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.326548131.9
2DLD Change Limit53800601.58034050.6
3Display Results60600.0134615.4
 (SQL Overall)178691601.91993116.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.