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

162 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
abortus939791(None) 
aborts84916181abort_s
abort76133582abort__
aborted10310422aborted
aborter939932aborter
aborters1038572aborters
abortuses1144992abortuses
amorous9311132amorous
aortas65417782a_ortas
arborous1047722arborous
borts76735452_bort_s
abacus10349763ab_acus
abates85825033ab_ates
abatis84317933ab_atis
abattis9297823abattis
abbots1039283abbot_s
abets75621673ab_et_s
abhors11410623abhor__s
ablates92416903ablates
ablauts936083ablauts
abodes94417513abo_des
abohms1335003abo_hms
aboiteaus1141893aboiteaus
abomas101113583abo_mas
abomasus1242853abomasus
aboral8314373abor_al
aborting11710253aborting
abortion1048103abortion
abortions1147783abortions
abortive1346883abortive
abos67734413abo___s
abounds10217083abounds
about75229083abo__ut
aboves114512843abo_ves
abris75722603ab_r_is
absorbs1135613absor_bs
abstruse1065513abstruse
abuts75417073ab_ut_s
abvolts12104373abvolt_s
abwatts1233403abwatts
acarus8312193acar_us
acerous9513333acerous
acorns85013013acor_ns
adopts998083adopt_s
adorers84411733adorers
adores74420723ador_es
adorns74212613ador_ns
agoras7613343agor_as
agoutis8286873agoutis
airbus848343a_irbus
airths95414253a_irths
airts55626343a_irt_s
alerts64418223alert_s
amort75832203amort__
amortise10428513amortise
anoraks1137603anoraks
anurous7311553anurous
aorta55922573a_ort_a
aortae65115473a_ortae
aortal65217513a_ortal
aortic8316613a_ortic
apercus1136573apercus
apodous1037403apodous
aporias9315153aporias
aport75432173aport__
arboreous1144293arboreous
arbores94016033arbor_es
arboretum1352543arboretum
arboretums1451783arboretums
arbors84717883arbor__s
arbutus944843arbutus
arcus76918863a__rcus
argus66716543a__rgus
arts49650263a__rt_s
asbestus1042953asbestus
assorts73310153assort_s
aureus65314883a_ureus
aurous64119263a_urous
averts95715243avert_s
azotes154312223azo_tes
azoths18366203azo_ths
berths114712423_berths
births115713603_births
boarts84716873_boart_s
boats75635153_boat_s
bogus85616473_bo_gus
boites84322703_boites
boletus948643_boletus
bolts76232113_bolt_s
bolus79125543_bo_lus
bonus75324323_bo_nus
booths115313793_booths
boots75837973_boot_s
borals86721913_borals
boras75938303_bor_as
borates94823013_borates
boreas85421733_boreas
borers85122683_borers
bores76448253_bor_es
borks115727703_bor_ks
borons85520543_borons
bort65960963_bort__
borty105522833_bort_y
bortz165722203_bort_z
bortzes1838223_bortzes
botas75328783_bo_tas
bots66453953_bo_t_s
botts75224863_bo_tts
bouts75131313_bout_s
broths115013923_broths
bruts75922953_b_ruts
canorous10310193canorous
cavorts1237933cavort_s
chorus115014773chor_us
coitus8511893_coitus
cornus84816563_cornus
corpus106015293_corpus
foetus958523_foetus
fortes95327183_fortes
fortis95418613_fortis
forts86034453_fort_s
habitus12338173hab_itus
harborous1445483harborous
jabirus1694573jabir_us
jabots1538883jabo_t_s
laborers10208383laborers
laborious1144763laborious
laborites1149253laborites
labors84016413labor__s
lotus55718063_lo_tus
morts75533563_mort_s
norths96812323_norths
obolus8378813obo_lus
odorous837663odorous
orts46538333__ort_s
porous84419483_porous
ports75934593_port_s
sabots8314703sabo_t_s
saporous1039053saporous
savorous1146603savorous
shorts95321743short_s
skorts104211303skort_s
snorts64116503snort_s
sorts54536663_sort_s
sorus54527583_sor_us
sports84619183sport_s
taborers10268333taborers
taborets10278063taborets
taborins103310223taborins
tabors84517113tabor__s
torous64319033_torous
tortas64918253_tortas
tortes64826053_tortes
torts56138123_tort_s
torus54329763_tor_us
valorous1147373valorous
vaporous1346483vaporous
vertus94613603_vertus
virtus94310143_virtus
whorts125111433whort_s
worths127812893_worths
worts88631183_wort_s

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 Limit1340271626.39020974.5
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.85926052.0
 
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.