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

201 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
virgate113873(None) 
virgates1237921virgates
airdate8311322airdate
cirrate92413492cirrate
ergate7315142_ergate
frigate11311062frigate
ingate73018242_ingate
irate55627982_ir_ate
ligate72519252li_gate
migrate101314172migrate
pirate82322882pir_ate
variate101316432variate
vibrate122811522vibrate
violate10311552violate
virga9310252virga__
virgas1048882virga_s
virgulate1345232virgulate
virgule1144282virgule
vitiate103412952vitiate
vittate10409732vittate
vulgate11388432vulgate
abrogate11129603abrogate
aerate64830553aer_ate
agate66525153__agate
airdates939723airdates
airfare1047243airfare
airwave1344433airwave
amirate91115953amir_ate
arrogate91210323arrogate
aurate64426473aur_ate
aureate72515283aureate
aviate9315203avi__ate
barbate11314543barbate
berate84729023ber_ate
bijugate1843513bijugate
binate8419773bi_nate
bistate9313823bistate
borate85026153bor_ate
brigade1136493brigade
burgage1136633burgage
bursate94111203bursate
carate84734003car_ate
cerate84829463cer_ate
ciliate9514603ciliate
citrate92216803citrate
cordate10315223cordate
crate76537403_cr_ate
create85126383_create
curate85226243cur_ate
curtate9312643curtate
derate74531233der_ate
derogate10311353derogate
dictate10311663dictate
dilate73220693di_late
dirge75117073dirg__e
disrate81418523disrate
divagate1344783divagate
emigrate1149603emigrate
emirate91015833emir_ate
ergates8314493_ergates
fermate122813003fermate
ferrate103014043ferrate
filiate10414233filiate
fissate103010033fissate
fixate1638733fi_xate
forgat104018583forgat_
forgave1435853forgave
formate123115093formate
frigates12310933frigates
furcate12310453furcate
gate55746573___gate
grate64932883_gr_ate
gyrate104912523gyr_ate
hirsute1084523hirsute
ideate7313683_ideate
ingates82716913_ingates
ingrate8715123_ingrate
inmate82917363_inmate
innate63917313_innate
iodate7313503_iodate
irade65618153_ir_ade
irater65218353_ir_ater
irrigate967633irrigate
jugate14379463_jugate
karate105320923kar_ate
legate72917453_legate
levigate1246623levi_gate
levirate1147623levir_ate
librate93214233librate
liftgate1243413liftgate
ligase7259913li_gase
ligated92414143li_gated
ligates82318383li_gates
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
litigate948303litigate
lyrate94112103lyr_ate
migrated121110513migrated
migrates111112853migrates
mirage92313653mir_age
misate81222693mi_sate
misdate101413963misdate
misgave13298283misgave
mismate111415353mismate
misrate91319143misrate
mitigate1148693mitigate
muriate9313363muriate
narrate7313493narrate
navigate1246073navi_gate
negate72915573_negate
nervate1039523nervate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrate72017013nitrate
ocreate93711743ocreate
orate55133303_or_ate
ornate6315133_ornate
overate10620963over_ate
overhate14312793overhate
overlate11716283overlate
overrate11615693overrate
picrate112014143picrate
pileate93815923pileate
pinnate93613743pinnate
pirated102515613pir_ated
pirates93020333pir_ates
prate75135983_pr_ate
primate111516283primate
private121513263private
rate45458763__r_ate
regrate82618663regrate
rugate75813813_rugate
seriate73722473seriate
serrate73017543serrate
sigmate10710143sigmate
sinuate7412163sinuate
situate7410783situate
sorbate9311733sorbate
striate74218953striate
tailgate946823tailgate
tergite8311003tergite
ternate7415483ternate
tirade7311693tir_ade
titrate72215573titrate
togate74515683_togate
turgite837973turgite
uprate83916543upr_ate
urate55432163_ur_ate
urinate7315363urinate
vacate11314553v_acate
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
variated121211393variated
variates111214983variates
variegate1344103variegate
vegete1039483v_egete
velate93720143v_elate
verge93419833verg__e
verite94323443ver_ite
verste94515633ver_ste
vibrated14228393vibrated
vibrates132210613vibrates
vibrato12247383vibrato
vicarate1378603vicarate
vicariate1476353vicariate
vicomte1445723vicomte
vidette1167543vidette
viga85622963vi_ga__
vigas94817883vi_ga_s
villae95615383villa_e
village113610833village
vintage11128143vintage
violated1237883violated
violater1137253violater
violates11311193violates
virago1046643vir_ago
viragoes1245233viragoes
viragos1146713viragos
viral86419593vir_a_l
virgin1038083virg_in
virgins1137863virgins
virgules1244333virgules
virile9313433vir_ile
virtu85314093vir__tu
virtue9358673vir_tue
visage1049083vi_sage
vitae84217633vi_ta_e
vitiated12289223vitiated
vitiates112311433vitiates
vittae93911003vitta_e
vivace1436553vi_vace
vizirate2045353vizirate
volvate13317993volvate
vorlage1136403vorlage
vulgates12237233vulgates
vulvate13388323vulvate
zincate1838533zincate
zingare1737143zingare

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272016.93619323.4
3Display Results2012010.0633190.5
 (SQL Overall)1786912017.14225019.7
 
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.