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

279 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
tibiae83848(None) 
tibia7312401tibia_
tibial849841tibial
tibias839951tibias
librae84310172librae
stibial946582stibial
stibine938662stibine
teniae64517352teniae
titian62512662titian
tubae74716642tub_ae
abide86223713_abide
actiniae101810013actiniae
albite8313313albite
antibias10312083antibias
bias64738163__bias
bible95119423bib_le
biblike1536893biblike
bice86235563__bice
bide76041483__bide
bike106532603__bike
bikie113915883biki_e
bile66147183__bile
bine66650863__bine
bise66437103__bise
bite66547003__bite
bize155926293__bize
blae66134643__blae
brae65639113__brae
cilia73016763cilia_
ciliate9514603ciliate
cilice103213353cilice
civie103716353civi_e
cobia94117513cobia_
cobias104014993cobias
curiae84518373curiae
dibble114013843dibble
didie74120563didi_e
divide113410893divide
divine103514463divine
dobie84920333dobi_e
faciae112913413faciae
feriae95618603feriae
fibre104812843fib_re
fibulae12237013fibulae
filial93013253filial
filiate10414233filiate
fimbriae1543773fimbriae
finial92814183finial
finite9316823finite
gibe75927783gib__e
gibing103712353gibing
habile11515213habile
ibices10398163_ibices
ibidem1134793_ibidem
ibis66519583_ibi_s
ibises83610543_ibises
ilia46026823_ilia_
iliac75013493_iliac
iliad64613463_iliad
ilial55317843_ilial
imbibe1234703imbibe
imide85716893_imide
imine75821063_imine
inia45024703_inia_
ixia115713213_ixia_
ixias12488373_ixias
jibe136323393jib__e
jibing16379623jibing
jubile152910263jubile
kibbe135211973kib_be
kibble143910953kibble
kibe106523443kib__e
kibitz2177643kibitz
kibla1139833kibla_
kiblah1535583kiblah
kiblas1239323kiblas
labia75219013labia_
labial84714343labial
labiate91313573labiate
labile8315223labile
lamiae84817453lamiae
liaise6310693liaise
libido935753libido
liblab1035083liblab
libra74712423libra_
libras83711703libras
librate93214233librate
lipide93511063lipide
mediae94217413mediae
milia72719573milia_
minae75627723mi_nae
misbias1139083misbias
mobile103613543mobile
nibble103713283nibble
niblike1336703niblike
niobite937953niobite
nixie125114943nixi_e
nubia7311233nubia_
nubias8310093nubias
nubile83212713nubile
obia67923113_obia_
obias76116863_obias
oidia6314953oidia_
pibal95217323pib_al
pinite8321243pinite
pinnae84414643pinnae
pixie145415523pixi_e
rediae74221993rediae
ribier84414233ribier
riblike1337333riblike
ribose839893ribose
sabine84020393sabine
sibilate1049533sibilate
silvae92811093silvae
simian8811163simian
simile83115633simile
stabile9312063stabile
stibines1038153stibines
stibium1145843stibium
stibnite1044073stibnite
stilbite1045423stilbite
striae65422273striae
tabid84418263tabi_d
tabla73318363tabla_
tablas83716163tablas
table75429603tab_le
tae38267053t___ae
taeniae739083taeniae
tafia84215493tafia_
tafias93111963tafias
tawie84819813tawi_e
taxite13511303taxite
telae54323293t_elae
telia55821143telia_
telial65815363telial
tenia55324483tenia_
tenias64720073tenias
terbia8311153terbia_
terbias9310743terbias
terrae62915213terrae
testae64216253testae
thae76825563t__hae
thecae11299653thecae
theine94814923theine
thine85026863t_hine
thrice114311573thrice
thrive125313223thrive
tiara5315913tiara_
tiaraed837053tiaraed
tiaras6314553tiaras
tical76021493ti_cal
tickle124616743tickle
tictac1036563tictac
tidal64516443ti_dal
tidbit938493tidbi_t
tidbits1035183tidbits
tide55237373t__ide
tidied83613273tidied
tidier73515113tidier
tidies74721833tidies
tidily102811393tidily
tiding83520093tiding
tie36557533t__i_e
tieing73518763tieing
tierce8339843tierce
tike85534483t__ike
tiki87620843tiki__
tikis95615973tiki_s
tikka835573tikka_
tikkas934523tikkas
tilak91011553ti_lak
tilde65017343ti_lde
tile45451443t__ile
tiling73426553tiling
tillage83111343tillage
tillite7313563tillite
timbal102510753timbal
timbale11248803timbale
timbral11237193timbral
timbre10328633timbre
time66235013t__ime
timid84815733timi_d
timider1037093timider
timing93619303timing
tincal83913363tincal
tine45855133t__ine
tinea54923163tinea_
tineal66216163tineal
tineas64616483tineas
tinge64626623ti_nge
tingle74319063tingle
tinier63622233tinier
tinily94014433tinily
tining74927543tining
tinkle103714453tinkle
tinlike11248803tinlike
tinman82411143tinman
tinware1038603tinware
tipcat10312653tipcat
tipi69924433tipi__
tipis76019923tipi_s
tipple103411913tipple
tiptoe838283tiptoe
tirade7311693tirade
tire46143353t__ire
tiring74023093tiring
tisane6311573tisane
tissue637333tissue
titan53318173ti_tan
titbit839823titbi_t
titbits935803titbits
tithe85319703ti_the
titi47130623titi__
titians72710453titians
titis56023813titi_s
titivate1146803titivate
title54721073ti_tle
titman82711003titman
titmice1144663titmice
titrate72215573titrate
titre54619393ti_tre
tittie63213153tittie
tittle63613323tittle
tobies84521023tobies
togae67020113t_ogae
toile54626493t_oile
towie85821873towi_e
toxine133114123toxine
triac74116373t_riac
triad65217723t_riad
triage72812893t_riage
trial54926353t_rial
tribade1037293tribade
tribal8611133trib_al
tribe74420273t_ribe
tribune945573tribune
tribute937313tribute
trice75127493t_rice
trike95320163t_rike
trine54734603t_rine
tripe75425383t_ripe
trite54730033t_rite
trivia938503trivia_
trivial1038713trivial
tuba65422363tub_a_
tubal75517203tub_al
tubas75119583tub_as
tubate82813173tubate
tube65828663tub__e
tubifex1942063tubifex
tubing93813093tubing
tubist83013163tubist
tublike1337083tublike
tubule839853tubule
tunicae9328143tunicae
turbine9310303turbine
twae74719573t__wae
twibil1133563twibi_l
twibill1242743twibill
twibils1253113twibils
twice104711123t_wice
twine85822363t_wine
umbrae1038683umbrae
unciae83215313unciae
urbia7311143urbia_
urbias839093urbias
utilise749063utilise
utilize1648813utilize
vibe95124503vib__e
vibist11610583vibist
vibrate122811523vibrate
vigia94813273vigia_
vigias104110893vigias
villae95615383villae
virile9313433virile
visive1257873visive
vitae84217633vi_tae
vitiate103412953vitiate
vittae93911003vittae

Search took 9 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.280638182.1
2DLD Change Limit1127162798.37613457.0
3Display Results2792790.0933000.0
 (SQL Overall)1786912798.74920424.2
 
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.