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

69 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
jivey18511187(None) 
jive146123591jive_
jived165115041jived
jiver155119051jiver
jives154820811jives
jivy176213111jiv_y
aiver85725162aiver
civet105828732civet
civvy16435462civvy
covey136121782covey
dicey114819332dicey
dikey135116422dikey
dive85634772dive_
dived106321372dived
diver94827802diver
dives95832402dives
divvy15356482divvy
five107629742five_
fiver116024942fiver
fives116027362fives
give85829352give_
given95915282given
giver94921202giver
gives95324872gives
hive106029672hive_
hived125217912hived
hives116925512hives
ivy96317442_iv_y
jarvey19135402jarvey
jibe136323392jibe_
jibed155114162jibed
jiber145115702jiber
jibes145520322jibes
jiffy21458312jiffy
jiggy17549142jiggy
jimmy19538502jimmy
jimpy195210822jimpy
jitney16304622jitney
jivers164515642jivers
jivier16438612jivier
joey145719332j_oey
jokey195014692jokey
limey104721042limey
liney87029632liney
live76540992live_
lived95523722lived
lively123310812lively
liven85021732liven
liver85132962liver
livery124910902livery
lives86133192lives
piney105727502piney
riley84420582riley
rive75537722rive_
rived94825612rived
riven85121622riven
river85731692river
rives85336002rives
rivet85636362rivet
siver85728612siver
tivy1014516862tiv_y
vive105426622vive_
wavey145115542wavey
wifey144913672wifey
winey115325432winey
wive105931752wive_
wived125121502wived
wiver115924512wiver
wives115328922wives

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.300595636.7
2DLD Change Limit53800691.56034487.2
3Display Results69690.0164312.5
 (SQL Overall)178691691.87695251.1
 
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.