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

230 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
vibrate12281152(None) 
librate93214231librate
vibrated14228391vibrated
vibrates132210611vibrates
vibrato12247381vibrato
cirrate92413492cirrate
citrate92216802citrate
disrate81418522disrate
irate55627982_i_rate
liberate101113382liberate
librae84310172libra_e
librated113110312librated
librates103412952librates
migrate101314172migrate
misrate91319142misrate
nitrate72017012nitrate
picrate112014142picrate
pirate82322882pi_rate
revibrate1446382revibrate
titrate72215572titrate
vibrance1545852vibrance
vibrant12410392vibrant
vibrants1345912vibrants
vibratile1443662vibratile
vibrative1745582vibrative
vibrator13227342vibrator
vibratos13217482vibratos
vicarate1378602vicarate
violate10311552violate
virgate1138732virgate
vitiate103412952vitiate
vittate10409732vittate
vizirate2045352vizirate
abate76627843_ab_ate
ablate82219213_ablate
abrade9313053_abrade
acerate92818913acerate
acierate10311813acierate
aerate64830553_aerate
airdate8311323airdate
amirate91115953amirate
aurate64426473_aurate
aviate9315203avi__ate
barbate11314543barbate
bate66552423__b_ate
berate84729023_berate
biforate1346903biforate
binate8419773bi_nate
bistate9313823bistate
blate75933783__blate
borate85026153_borate
brace95629273__brace
brae65639113__bra_e
brake116025343__brake
brat66055543__brat_
brats75336013__brats
brave104925503__brave
braze165423453__braze
brute75321783__brute
calibrate1347743calibrate
carate84734003_carate
cerate84829463_cerate
ciliate9514603ciliate
citrated112712253citrated
citrates102315093citrates
crate76537403__crate
curate85226243_curate
debate94419193deb_ate
derate74531233_derate
dictate10311663dictate
dilate73220693di_late
diorite8314913diorite
disrated10915573disrated
disrates91118153disrates
embrace1388893embrace
embrute1145703embrute
emigrate1149603emigrate
emirate91015833emirate
ferrate103014043ferrate
fibranne1343373fibranne
fibre104812843fibr__e
figurate1237193figurate
filiate10414233filiate
filtrate1148223filtrate
fimbriate1643823fimbriate
fissate103010033fissate
fixate1638733fi_xate
glabrate1146043glabrate
grate64932883__grate
gyrate104912523_gyrate
hibernate1444993hibernate
hydrate14239813hydrate
ideate7313683_ideate
imbrute1144913imbrute
ingate73018243_ingate
ingrate8715123ingrate
inmate82917363_inmate
innate63917313_innate
iodate7313503_iodate
irade65618153_i_rade
irater65218353_i_rater
iterate71119113iterate
karate105320923_karate
labiate91313573labiate
levirate1147623levi_rate
liberated1299473liberated
liberates111012943liberates
libra74712423libra__
library1245323library
libras83711703libra_s
ligate72519253li_gate
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
literate81216893literate
lobate82915243lob_ate
lyrate94112103_lyrate
migrated121110513migrated
migrates111112853migrates
mirage92313653mi_rage
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrated111315383misrated
misrates101318243misrates
narrate7313493narrate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrated92213153nitrated
nitrates82516223nitrates
nitrite72314463nitrite
oblate82214743_oblate
operate9615733operate
orate55133303__orate
outrate72323183outrate
overate10620963overate
overrate11615693overrate
phorate12413363phorate
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite
pileate93815923pileate
pinnate93613743pinnate
pirated102515613pi_rated
pirates93020333pi_rates
prate75135983__prate
priorate10411733priorate
prorate9418733prorate
rate45458763___rate
rebate84424113reb_ate
recrate92621663recrate
regrate82618663regrate
revibrated1645443revibrated
revibrates1546273revibrates
serrate73017543serrate
sibilate1049533sibilate
sigmate10710143sigmate
sinuate7412163sinuate
situate7410783situate
sorbate9311733sorbate
sublate9315363sublate
subrace11313003subrace
tibiae838483tibia_e
tirade7311693ti_rade
titrated92611683titrated
titrates82314663titrates
tubate82813173tub_ate
umbrae1038683umbra_e
umbrage1236723umbrage
unbrace111910493unbrace
unbrake13239123unbrake
uncrate9415953uncrate
uprate83916543_uprate
urate55432163__urate
vacate11314553v_acate
valerate11311473valerate
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
vambrace1743983vambrace
variate101316433variate
velate93720143v_elate
venerate11312903venerate
verite94323443v_erite
verste94515633v_erste
vibe95124503vib___e
vibist11610583vibist_
vibists1256483vibists
vibrances1645763vibrances
vibrancy1843873vibrancy
vibrantly1743403vibrantly
vibrating1537483vibrating
vibration14138203vibration
vibrators14237253vibrators
vibratory17235563vibratory
vibrio1136223vibr_io
vibrion1245253vibrion
vibrios1235803vibrios
vicarage1444433vicarage
vicarates1487623vicarates
vicariate1476353vicariate
vicomte1445723vicomte
vidette1167543vidette
villae95615383villa_e
village113610833village
vintage11128143vintage
violated1237883violated
violater1137253violater
violates11311193violates
virago1046643vi_rago
viral86419593vi_ra_l
virgates1237923virgates
virile9313433vi_rile
virtu85314093vi_r_tu
virtue9358673vi_rtue
visage1049083vi_sage
vitae84217633vi_ta_e
vitiated12289223vitiated
vitiates112311433vitiates
vitrain1038943vitrain
vitrine102511363vitrine
vittae93911003vitta_e
vivace1436553vi_vace
vizierate2143663vizierate
vizirates2144663vizirates
volvate13317993volvate
vulgate11388433vulgate
vulvate13388323vulvate
zincate1838533zincate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272305.87622809.2
3Display Results2302300.0763026.3
 (SQL Overall)1786912306.35828104.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.