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

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
tiderip104551(None) 
tiderips1145381tiderips
aider65431133aider__
aiders74524633aider_s
bider85728373bider__
biders94822803bider_s
cider84723313cider__
ciders94620093cider_s
cinerin9313823cinerin
dimeric12310013dimeric
dineric10310973dineric
drip76223953__d_rip
eider64624743eider__
eiders74321363eider_s
eidetic1039743eidetic
hider95024083hider__
hiders104919653hider_s
midrib1138243mid_rib
midship1546043midship
nidering10510483nidering
niterie7313743niterie
rider65231303rider__
riders74123903rider_s
ridership1545133ridership
siderite9411363siderite
sideslip1143333sideslip
thrip103012183t__hrip
tidbit938493tid_bit
tide55237373tide___
tided76322513tide__d
tidelike1336743tidelike
tides64830153tide__s
tideway1445153tideway
tidier73515113tidier__
tidiers8389773tidier_s
tidytips1441683tidytips
tiepin839343ti_epin
tier44936143ti_er__
tierce8339843ti_erce
tiered73613973ti_ered
tiering8315253ti_ering
tiers55526523ti_er_s
tiger65718633tiger__
tigerish1246563tigerish
tigers75616513tiger_s
tiler56131023tiler__
tilers63523503tiler_s
timer75626043timer__
timers84420993timer_s
tinder73821803tinder__
tinders84219173tinder_s
tindery11389363tinder_y
tineid74412023tine_id
titer55430613titer__
titers64526413titer_s
trimeric1246933trimeric
trip66830393t___rip
twerp10398413t_wer_p
underlip11157203underlip
wider94826353wider__

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027608.62615537.6
3Display Results60600.0163750.0
 (SQL Overall)178691608.79820310.4
 
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.