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

57 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
ipecacs135450(None) 
ipecac1264621ipecac_
icecaps1343862icecaps
pecans101515832_pecans
apicals1159923apicals
arecas84817453areca_s
becaps123811403_becaps
decafs124010883_decafs
decals93717713_decals
decays124612913_decays
hepcats1436473hepcats
icecap1245223iceca_p
ideals75012503ide_als
ideas65919013ide_a_s
ileac75814173ile_ac_
impeach1644273impe_ach
inexact1647413inexact
irenics937833irenics
meccas1239493_meccas
operas8312453opera_s
pacas96029403_paca_s
pacs85842183_p__acs
peace95026083_pe_ace
peaces106324083_peaces
peach125422493_pe_ach
peags86122843_pe_ags
peaks114825623_pe_aks
peals75235493_pe_als
peans75437643_pe_ans
pears75138613_pe_ars
peas65755063_pe_a_s
peats76140193_pe_ats
pecan91919033_peca_n
pechans14810503_pechans
pechs125516203_pec_hs
pecks135724433_pec_ks
pecs84634103_pe__cs
pedals94316033_pedals
pekans121710553_pekans
petals84719813_petals
picas94626523_pica_s
piecers114112253piecers
pieces104217273piec_es
pietas84516503pieta_s
recaps103615733_recaps
seracs84418573_seracs
sidecars1145903sidecars
speaks125114583spe_aks
speans85417143spe_ans
spears84019473spe_ars
specials1238033specials
species11314133species
specks144312703spec_ks
specs96916673spe__cs
spicas104715823spica_s
tipcats1137103tip_cats
toecaps1135553toecaps

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.390458182.1
2DLD Change Limit134027578.51615738.3
3Display Results57570.0163562.5
 (SQL Overall)178691578.92220028.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.