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

75 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
wikiup1518353(None) 
wickiup18172671wickiup
wikiups16132081wikiups
wickiups19181962wickiups
wickyup21171882wickyup
windup1235382windup
aikido1135473aikido
bikie113915883biki_e
bikies124515163bikies
biking135018173biking
bikini12418913bikini
cilium104311373cilium
diking124320243diking
hiccup1554393hiccup
hiking143617103hiking
ilium74614183_ilium
kickup1354133kickup
kip97042133__ki_p
liking114319583liking
lineup835983lineup
linkup1245123linkup
makeup1434863makeup
miking134218463miking
milium104712683milium
minium106014423minium
mixup1636773mi_xup
oidium959813oidium
oilcup1044253oilcup
pickup1655633pickup
piki106520563piki__
piking133719643piking
pikis115116393piki_s
pileup10437923pileup
pinup9612883pi_nup
qiviut1846613qiviut
sirup74014913si_rup
situp74414063si_tup
skimp135411323_skimp
skip105421753_ski_p
takeup1234583takeup
tiki87620843tiki__
tikis95615973tiki_s
tittup834203tittup
viking143414613viking
wakiki1233463wakiki
waking144821383waking
walkup1534193walkup
warmup1335343warmup
washup1435323washup
whaup13458883w_haup
whip125521843w_hi_p
whup125714163w__hup
wicking173414773wicking
wickyups22171773wickyups
widish13419363widish
wifing133513393wifing
wilful1235963wilful
wilier93217073wilier
wilily123310763wilily
wiling103024293wiling
wimp115521523w__imp
windups1334783windups
winier94522453winier
wining103625053wining
winish124212263winish
winking153317963winking
wiping123916713wiping
wirier94215553wirier
wirily123310783wirily
wiring104521023wiring
wising103318223wising
wisp97124073w__isp
witing103522823witing
wiving133316603wiving
workup1534323workup

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.1261418182.5
2DLD Change Limit112716755.45320670.5
3Display Results75750.0302500.0
 (SQL Overall)178691755.60931857.9
 
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.