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

92 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
ipecac126462(None) 
ipecacs1354501ipecacs
icecap1245222icecap
ileac75814172ile_ac
pecan91919032_pecan
apeak115513453ape_ak
apical10913903apical
areca75618633areca_
arecas84817443arecas
becap114315053_becap
bipedal1245683bipedal
caeca93915133caeca_
caecal103713733caecal
ceca84820783_ceca_
cecal94619113_cecal
decaf114919443_decaf
decal85523233_decal
decay114718483_decay
epical10413393epical
faecal11359813faecal
fecal105119213_fecal
hepcat13611823hepcat
icecaps1343863icecaps
iceman1037853iceman
idea59122773ide_a_
ideal65716393ide_al
ideas65919013ide_as
ilea45931463ile_a_
ileal56118083ile_al
iliac75013493i_liac
impeach1644273impeach
inexact1647413inexact
irenic8311103irenic
mecca1139933_mecca
opera7313573opera_
operas8312453operas
pac79054083_p__ac
paca85132243_paca_
pacas96029403_pacas
pea56657243_pe_a_
peace95026083_peace
peach125422493_peach
peag75431343_pe_ag
peak106535203_pe_ak
peal68648103_pe_al
pean66147173_pe_an
pear69745233_pe_ar
peas65755063_pe_as
peat65967933_pe_at
pec76744413_pe__c
pecans101515833_pecans
pech116125453_pec_h
pechan13511543_pechan
pechs125516203_pechs
peck125730683_pec_k
pecks135724433_pecks
pecky165515093_pecky
pecs84634103_pec_s
pectic122913873_pectic
pedal86022503_pedal
pekan111613973_pekan
penal75228373_penal
petal76526893_petal
pica85831493_pica_
pical95524373_pical
picas94626523_picas
piece96717993piec_e
pieced113912103pieced
piecer105213083piecer
pieces104217273pieces
pieta75421753pieta_
pietas84516503pietas
recap95718023_recap
serac75925203_serac
sidecar1045233sidecar
speak114618673spe_ak
spean74620513spe_an
spear75821063spe_ar
spec85821973spe__c
special11310303special
specie10412223specie
speck135115653spec_k
specks144312703specks
specs96916673spec_s
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
theca103311453theca_
thecae11299653thecae
thecal113310303thecal
tipcat10312653tip_cat
toecap1037323toecap

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit112716925.26621404.5
3Display Results92920.0137076.9
 (SQL Overall)178691925.65531598.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.