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

89 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
abortions114778(None) 
abortion1048101abortion_
ablations11311512ablations
ablutions1146602ablutions
abolitions1246652abolitions
aborting11710252aborti_ng
abortionist1356162abortionist
absorptions1544592absorptions
adoptions1245782adoptions
adorations11310232adorations
amotions1069842amo_tions
apportions1446282apportions
portions10514412_portions
abductions15125383abductions
aberrations1346693aberrations
abjections2145673abjections
abjurations2045143abjurations
ablation10312433ablation_
ablution1047223ablution_
abolition1147053abolition_
aborning1188003aborni_ng
aborters1038573abort_ers
abortionists1454973abortionists
abortive1346883aborti_ve
aborts84916183abort___s
abortus9397913abort__us
abortuses1144993abortuses
abrasions1145813abrasions
abrogations14116463abrogations
abruptions1443843abruptions
absolutions1344713absolutions
absorption1444883absorption_
abutilons1142963ab_utilons
accordions1552733accordions
accretions1444923accretions
actions94218513a__ctions
adaptions1245223adaptions
additions1186333additions
adnations1039753adnations
adoption1146083adoption_
adoration10311313adoration_
adsorptions1444163adsorptions
aerations9317903aerations
agnations10310033agnations
alations82518893a_lations
ambitions1346343ambitions
amortises1178823amortises
amortizes2087283amortizes
amotion9710473amo_tion_
apportion1347003apportion_
assertions1046583assertions
attritions1066793attritions
auctions104012143a_uctions
auditions1078753auditions
aversions1247053aversions
aviations12311553aviations
avocations15168683avocations
bastions10411693_bastions
borons85520543_bor__ons
bostons9312903_bost_ons
boutons9310783_bout_ons
burtons9310853_burt_ons
chorions13310663chor_ions
coitions10312853_coitions
cooptions13107763cooptions
cortins92421333_corti_ns
elaborations1444923elaborations
emotions10610283emo_tions
exertions1639763exertions
extortions1746473extortions
laborious1144763labor_ious
lobations11219613lobations
lotions74614763_lo_tions
morions94014643_mor_ions
morrions1077673_morrions
motions94215003_mo_tions
notions74014483_no_tions
oblations1139373oblations
options93810603__options
orations81515803__orations
portion9615493_portion_
potions93417423_po_tions
prorations12314463prorations
retortions1049143retortions
scorpions1344213scorpions
sorptions1137123_sorptions
taborins103310223tabor_i_ns
torsions839183_torsions
tortious839023_tortious

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 Filter1786911486410.423422437.4
2DLD Change Limit148641897.29620372.9
3Display Results89890.0302966.7
 (SQL Overall)178691897.74923059.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.