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

74 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
tidying1238511tidying
tiding83520092tid_ing
aiding84423613aid_ing
bidding123613513bidding
biding104720793bid_ing
bodying1438973bodying
dying105316033__dying
eddying1335293eddying
fidging133910503fidging
giddying1533783giddying
hiding114319333hid_ing
idling8912883_idling
kidding14389773kidding
kiddish16276583kiddish
ladyish14287823ladyish
lidding103611433lidding
midline102315103midline
niding83217983nid_ing
pidgin10259813pidgin_
pidgins11259123pidgins
pinyin112710613pinyin_
pitying132910243pitying
pixyish2253653pixyish
ridding103314193ridding
ridging104112983ridging
riding84325963rid_ing
siding83822133sid_ing
sidling9915423sidling
stimying1437503stimying
studying1335553studying
taxying1836183taxying
tedding103210883tedding
ticcing12308633ticcing
ticking143218753ticking
tidbit938493tidbi_t
tidbits1035183tidbits
tidied83613273tid_ied
tidier73515113tid_ier
tidies74721833tid_ies
tidily102811393tid_ily
tidings93810263tid_ings
tidy86822423tidy___
tidytips1441683tidytips
tieing73518763ti_eing
tiepin839343tiepin_
tiepins939463tiepins
tiering8315253tiering
tiffin12327933tiffin_
tiffing14339383tiffing
tiffins13327983tiffins
tigrish1137573tigrish
tiling73426553ti_ling
tilling83522783tilling
tilting83417103tilting
timing93619303ti_ming
tinging93619463tinging
tining74927543ti_ning
tinning83117283tinning
tinting84620603tinting
tipping122814973tipping
tiring74023093ti_ring
tirling83315733tirling
tithing113513893tithing
titling83715793titling
toadying1335043toadying
toadyish1544153toadyish
toying105017303t_oying
toyish122911123t_oyish
trying104214073t_rying
tyin76424003t__yin_
tying96019843t__ying
undying1238503undying
untidying1445473untidying
widish13419363wid_ish

Search took 8 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.420425454.8
2DLD Change Limit134027746.69020033.9
3Display Results74740.0302466.7
 (SQL Overall)178691747.14025026.8
 
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.