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 “icterus” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

190 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
icterus93607(None) 
citers85022982citer_s
citrus83610922cit_rus
ickers123914182icker_s
icteric1138022icteric
icterics1247052icterics
icteruses1144972icteruses
ictus7249702ict__us
interns73116772interns
inters64328052inter_s
iterum837902i_terum
uterus639202_uterus
acarus8312193ac_arus
acerous9513333ac_erous
acetous9410363acetous
actors81016763actor_s
actress948533actress
afters94717073after_s
alters64924223alter_s
apterous10410463apterous
asters65631603aster_s
auteurs7137503auteurs
bickers154316553bicker_s
bisters93922613bister_s
biters83925243biter_s
bitterns10428953bitterns
bitters94920363bitter_s
caters85336503cater_s
cercus105013153_c_ercus
ceres75540013_c_eres
cereus85215523_c_ereus
ceros74726073_c_eros
cerous85821203_c_erous
ceruse83914523_c_eruse
cherts115617233_cherts
cherub1337263_cherub
cherubs1434553_cherubs
chirus114615693_chirus
chorus115014773_chorus
ciceros1158583ciceros
ciders94620093cider_s
cirrus8349173_cirrus
cisterns10369573cisterns
citer74827333citer__
cites74435593cite__s
citherns13338873citherns
cithers124315773cither_s
citreous1056853citreous
citrous93112993citrous
citrusy12284183cit_rusy
citterns10318123citterns
clerks12458843_clerks
crus65828483_c__rus
cyprus1335363_cyprus
daters74827373dater_s
deters74724683deter_s
dicers94720743dic_er_s
dickers144117663dicker_s
dieters83216433dieter_s
dipterous1256283dipterous
doters74423913doter_s
duteous838453duteous
eaters65535953eater_s
ecrus75113863ec__rus
enters64425643enter_s
esters64627733ester_s
estrus61912113est_rus
externs1438233externs
filters103816553filter_s
fitters104517753fitter_s
gateaus866333gateaus
gaters74728643gater_s
gitterns9326573gitterns
haters94930403hater_s
heteros10312683heteros
hinters103719583hinter_s
hitters104717593hitter_s
humerus1236913humerus
icebergs1341963icebergs
ices66129643ic_e__s
ichorous1346983ichorous
ichors11310423ichor_s
icier74313753icier__
icker114018443icker__
ictuses938303ictuses
idlers74012813idler_s
igneous835773igneous
ileus54616893i_le_us
impetus1144893impetus
inchers123912523incher_s
inciters103210673inciter_s
inerts64517023i_nerts
infers93615443infer_s
inheres10315173inheres
inkers104018833inker_s
inners63919353inner_s
inserts74013993inserts
intends8239963intends
intents72115703intents
inter55028493inter__
intercut10411113intercut
intercuts1148783intercuts
interest8319183interest
interfuse1247433interfuse
interim9912873interim
interims101013073interims
intern64016543inter_n
interne73218153interne
internes82721233internes
intorts7310973intorts
intros64215773int_ros
intrust7311493int_rust
inturns73210133inturns
inverts103211953inverts
isthmus1243263isthmus
items7499613i_te_ms
jilters144211963jilter_s
jitters144314473jitter_s
kickers124013293kicker_s
kilters113813603kilter_s
kiters105218593kiter_s
lacteous1046773lacteous
lecterns1035943lecterns
lickers134118253licker_s
lictors93212593lictor_s
lifters104313783lifter_s
linters73822633linter_s
listers74026533lister_s
liters65429883liter_s
litters73422573litter_s
luteous739273luteous
maters85032393mater_s
meters85625833meter_s
midterms13284863midterms
milters93619093milter_s
minters93822473minter_s
misterms123711353misterms
misters93927513mister_s
miters84328783miter_s
nickers134415093nicker_s
niters64624213niter_s
noters64021003noter_s
oaters65029793oater_s
ocherous1347013ocherous
ochers113915303ocher_s
ockers123813903ocker_s
octets839403octe_ts
octopus1144813octopus
otters64021513otter_s
outers64230173outer_s
oxters134813273oxter_s
paters84935833pater_s
peters86624593peter_s
piceous11310693pic_eous
pickers153718093picker_s
pictures1249343pictures
piteous9310683piteous
raters63936583rater_s
ricers84120993ric_er_s
rictus8379193rict__us
rioters73615513rioter_s
ritters74020623ritter_s
scleras948223scleras
sclerous1047923sclerous
scoters93313813scoter_s
sifters103714793sifter_s
sinters74024083sinter_s
sisters73721593sister_s
sitters74221553sitter_s
steres63929533_steres
sterns64616763_sterns
taters64932203tater_s
terms75523473__terms
terns55226873__terns
tickers133617723ticker_s
tilters73315953tilter_s
tinters74221113tinter_s
titers64526413titer_s
titters74219623titter_s
torus54329763__torus
toters65026363toter_s
utters63817123utter_s
victors123311183victor_s
victress1344523victress
voters95017443voter_s
waterbus1345863waterbus
waters95030633water_s
wickers164114703wicker_s
winters103720483winter_s
xerus12313333__xerus

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.406440125.6
2DLD Change Limit1340271906.72019944.5
3Display Results1901900.0603166.7
 (SQL Overall)1786911907.18624866.5
 
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.