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

91 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
oilcup104425(None) 
oilcups1143331oilcups
hiccup1554392hiccup
oilcamp1343052oilcamp
oilcan837792oilcan
pileup10437922pileup
bicep115413543bi_cep
buildup1242333buildup
cilium104311373cilium
circus104310593circus
cup76738243___cup
discus94512113discus
eggcup1241833eggcup
eyecup1344493eyecup
ficus105015493fi_cus
filch134813323filc_h
fillip11268953fillip
filum105015433fil_um
foldup1233813foldup
gelcap1136213gelcap
hiccups1643223hiccups
hilum105514603hil_um
hilus84817643hil_us
holdup1245183holdup
ileum74512823_ileum
ileus54616893_ileus
ilium74614183_ilium
incur72212253_incur
incus73315053_incus
kickup1354133kickup
kingcup1642473kingcup
lineup835983lineup
linkup1245123linkup
loup66028433__loup
midcap1336473midcap
milch124413373milc_h
milium104712683milium
miscue10412223miscue
miscut10614823miscut
mixup1636773mi_xup
occupy1543153o_ccupy
occur9137323o_ccur
offcut1444703offcut
oidium959813oidium
oil37452053oil___
oilcamps1442163oilcamps
oilcans936813oilcans
oiled64429473oil_ed
oiler54628283oil_er
oilers64721193oilers
oilier64417233oilier
oilily93111723oilily
oiling74925313oiling
oilman839483oilman
oilmen848313oilmen
oils46337973oil__s
oilway1235743oilway
oily77932253oil__y
oleum73613323o_leum
orlop7410903orl_op
oxlip1456883oxl_ip
pickup1655633pickup
picul95015363pi_cul
pilau73618523pilau_
pilaus84114133pilaus
pileum10399513pileum
pileups11365433pileups
pileus84514943pileus
pilous84717753pilous
pilus75921063pil_us
pinup9612883pi_nup
poilu72316003poil_u_
poilus82210573poil_us
pullup1045893pullup
scup84822383__scup
sirup74014913si_rup
situp74414063si_tup
slipup1034503slipup
sulcus8410493sulcus
talcum1036953talcum
teacup1036253teacup
tittup834203tittup
toilful1044813toilful
villus93611223villus
viscus11428503viscus
walkup1534193walkup
wikiup15183533wikiup
wilco1039443wilc_o
wilful1235963wilful
windup1235383windup
zilch19438123zilc_h

Search took 7 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.390458182.1
2DLD Change Limit112716915.76619548.4
3Display Results91910.0303033.3
 (SQL Overall)178691916.18628886.4
 
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.