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

88 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
zibeline194636(None) 
zibelines2045731zibelines
zibelline2044301zibelline
libeling1139872libeling
lifeline11167662lifeline
lobeline1039962lobeline
pipeline12149502pipeline
sideline91011092sideline
timeline1039242timeline
zibellines2143492zibellines
aiblins9311473aib_lins
airline7315033ai_rline
baseline10310753baseline
beeline93314723_beeline
belie75630383__beli_e
belike124616283__belike
belive115415303__belive
berline93716853__berline
biblike1536893bib_like
blueline1036873blueline
bubaline1247163bubaline
byline11311643__byline
dateline9810353dateline
dibbling14247333dibbling
driveline1345353driveline
feline94820143__feline
fiberize2246143fiberize
fiberlike1844123fiberlike
figuline1256033figuline
fishline14237583fishline
guideline1143983guideline
hipline12311423hi_pline
hireling121210993hireling
icelike1337173_icelike
incline9314643_incline
isoline7314013_isoline
kibbling17225703kibbling
kitelike1135733kitelike
labeling11311643labeling
libelant1048563libelant
libelee92510983libel_ee
libelist10310823libelist
libellee10227733libellee
libelling1236873libelling
libertine1147433libertine
lifelike15166223lifelike
lifelines12147053lifelines
linelike12159003linelike
lobelines1138563lobelines
midline102315103mi_dline
milline92519113mi_lline
myeline1238253_myeline
nibbling13256503nibbling
niblike1336703nib_like
obelise9310173_obelise
obelize1838243_obelize
picoline12310853picoline
pinelike14188613pinelike
pipelike16166693pipelike
pipelined14164853pipelined
pipelines13178353pipelines
piperine122011833piperine
reline65434353__reline
riblike1337333rib_like
ridgeline11174723ridgeline
riverine11310803riverine
sibling10814423sib_ling
sibylline1442893sibylline
sidelined11125883sidelined
sideliner10126013sideliner
sidelines10109683sidelines
sideling101012183sideling
subline9316893sub_line
tapeline10310363tapeline
tidelike1336743tidelike
tilelike1237053tilelike
timberline1473833timberline
timelines1148443timelines
tubelike1436093tubelike
vaseline1138613vaseline
viperine13189713viperine
viselike1536923viselike
vitelline1285853vitelline
vituline1147093vituline
wifelike18135253wifelike
wirelike15167493wirelike
zebrine1836463zeb_rine
zizzling16233923zizzling

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 Filter1786911461620.453394461.4
2DLD Change Limit146162886.73621698.6
3Display Results88880.0461913.0
 (SQL Overall)178691887.23524698.1
 
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.