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

94 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
zaptieh214456(None) 
zaptiah2144291zaptiah
zaptiehs2241861zaptiehs
zappier20458372zappier
zaptiahs2242062zaptiahs
apish105116633_ap_ish
apter76120203_apt_er
artier63419733_artier
banties94324763banties
baptise1139553baptise
baptised1335263baptised
baptises1238923baptises
baptism1337803baptism
baptist11311873baptist
baptize2036983baptize
baptized2245483baptized
baptizer2134893baptizer
baptizes2136843baptizes
battier93515713battier
bawtie113812143bawtie_
bawties124214313bawties
caption113513693caption
captive1438973captive
captives1538623captives
cattie85221023cattie_
cattier93317073cattier
catties94023053catties
cattish12410723cattish
dautie72914703dautie_
dauties83315763dauties
dawtie103011093dawtie_
dawties113312703dawties
emptied1297393emptied
emptier1187603emptier
empties11712243empties
fattier103513463fattier
fatties103018203fatties
fattish1359263fattish
gappier12369843gappier
happier143312033happier
hapten115312983hapt_en
haptic13511893hapti_c
hastier103916623hastier
laities7320343laities
latish92416173la_tish
maltier93015483maltier
matier84321523ma_tier
nappie104112263nappie_
nappier114411173nappier
nappies114613393nappies
nastier74115293nastier
nasties73520493nasties
nattier73614623nattier
pantie84326473pantie_
panties94230933panties
pappier103511593pappier
pappies103214823pappies
partied103516553partied
partier93520713partier
parties93230863parties
pastie85525523pastie_
pastier94320383pastier
pasties94529813pasties
pattie84020963pattie_
patties93425143patties
rapier84019993rap_ier
rattier74015593rattier
rattish10510823rattish
saltie63422433saltie_
saltier74318633saltier
salties73725773salties
saltish10312163saltish
sappier113613113sappier
tartier74123263tartier
tartish101512633tartish
tastier711817093tastier
tattie64817513tattie_
tattier74216243tattier
tatties74120343tatties
vastier103613203vastier
wartier103413913wartier
zaftig1933253zafti_g
zanier154314713za_nier
zanies153219673za_nies
zanyish2235903zanyish
zapateo1844593zapateo
zapped204213523zap_ped
zapper193414023zap_per
zappiest21228023zappiest
zapping213211473zapping
zestier163010223zestier
zippier20308193zippier
zloties1639913zloties
zootier163611173zootier

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.1561145455.1
2DLD Change Limit134027947.18618651.1
3Display Results94940.0501880.0
 (SQL Overall)178691947.39224173.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.