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

73 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
zibeths214293(None) 
zibeth2034171zibeth_
zibets1737741zibet_s
beths105519222__beths
zibet16419732zibet__
abets75621673_abet_s
airths95414253ai_rths
azimuths2241363azimuths
baths105922923__baths
berths114712423__berths
betas75528763__betas
beth96629233__beth_
bets67051443__bet_s
bidets95215533bidet_s
births115713603bi_rths
cheths14389823_cheths
civets115212543civet_s
daleths1135323daleths
diabetes1147023diabetes
diets66026643di_et_s
ebbets10376833ebbet_s
eighths14388293eighths
eths76619523___eths
fibers114717523fibe_rs
fifths15406543fi_fths
filets94718953filet_s
filths12389783fi_lths
firths125113503fi_rths
gibbets12417723gibbet_s
gibers95114663gibe_rs
gibes84422523gibe__s
giblets103210423giblet_s
girths105612273gi_rths
heths116317783__heths
highths13358003highths
ibexes15436163_ibexes
jibers155912883jibe_rs
jibes145520323jibe__s
kheths16495973_kheths
kibbehs18354183kibbehs
kibeis12469803kibe_is
kibes115521113kibe__s
kiblahs1634153kiblahs
kiths125814973ki__ths
libels85112693libe_ls
libers84721443libe_rs
meths105320233__meths
mirths114912993mi_rths
ninths936933ni_nths
obeahs1135863_obeahs
pietas84516503pi_etas
pipets105714773pipet_s
piths105817543pi__ths
ribes75530173ribe__s
riblets93412553riblet_s
rivets94417113rivet_s
sixths16416373si_xths
teths85418513__teths
tilths9459373ti_lths
turbeths1373353turbeths
vibes104719953vibe__s
widths1335123wi_dths
yirths12639533yi_rths
zebecks24274193zebecks
zebecs19316183zebe_cs
zeniths1935153zeniths
zetas145018163z__etas
zillahs1935383zillahs
zinebs17606803zine_bs
zines145232653zine__s
zitis145815583zi__tis
zits136030293zi__t_s
zizith1744823zizith_

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.403443402.0
2DLD Change Limit134027736.97019229.1
3Display Results73730.0302433.3
 (SQL Overall)178691737.40324137.6
 
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.