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

112 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
orbital93692(None) 
orbitals1045711orbitals
arbitral1045422arbitral
barbital1247052barbital
cubital1137102cubital
forbidal1444832forbidal
orbit73622062orbit__
orbited1037732orbited
orbiter937852orbiter
orbits84211442orbit_s
ordinal838632ordinal
sorbitol1043742sorbitol
albinal937813albinal
aortal65217513aor__tal
arbiter939933arbiter
arrival1037563arrival
artal55525473ar__tal
barbitals1345253barbitals
binal75323823__binal
borstal939043bor_stal
bridal9511453br_idal
brutal859383br_utal
capital112311523capital
chital114313883_chital
coital84117053_coital
corbina111911453corbina_
corbinas12229393corbinas
cordial10312943cordi_al
corrival1346153corrival
cortical12412213cortical
crestal9312133crestal
crustal939023crustal
cryptal1445683cryptal
crystal1237433crystal
cubical1338463cubical
digital937063digital
forbidals1543493forbidals
forestal11410283forestal
fornical1347793fornical
fractal1237623fractal
frontal1038363frontal
genital849793genital
gordita945093gordita_
gorditas1043923gorditas
habitan1236903habitan
habitat12411053habitat
habitual1343493habitual
hospital1344743hospital
invital1046953invital
labial84714343labi_al
lanital7310913lanital
marital92314183marital
morainal1047203morainal
mortal84616853mor__tal
nonvital1147023nonvital
obia67923113o_bi_a_
obias76116863o_bi_as
obit66837083o_bit__
obits74617553o_bit_s
octal71214723o__ctal
oedipal1045173oedipal
ogival1035873o_gival
omental93210413omental
optical1149863optical
optimal1145783optimal
oral47638123or___al
orbier839993orbi_er
orbiest9312413orbiest
orbing93312363orbi_ng
orbiters1036593orbiters
orbiting1138153orbiting
orcinol944703orcinol
ordeal779253or_deal
ordinals946753ordinals
orgiac934993orgi_ac
oriel54920423or_i_el
oriental848483oriental
origan7310693or_igan
original956793original
orphical1546733orphical
ovoidal1144023ovoidal
portal84218463por__tal
primal104014623pr_imal
raita54623073_raita_
raitas64417673_raitas
ratal55025113_r_atal
recital9412163recital
rectal84418133_rectal
rental63922023_rental
retial64724993_retial
rhinal9510193_rhinal
rial45938093_r_i_al
rictal83113183_rictal
ritual6310623_r_itual
rival85216503_r_ival
riyal84413433_r_iyal
somital939403somital
sorbitols1142923sorbitols
spital83813873_spital
suborbital1453263suborbital
tibial849843tibi_al
toroidal966393toroidal
trial54926353tr_i_al
tribal8611133tr_ibal
trinal6516963tr_inal
turbinal1045623turbinal
urbia7311143urbi_a_
urbias839093urbi_as
urial54823023ur_i_al
urinal6614123ur_inal
vital84819673__vital
vortical1348863vortical

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.406440125.6
2DLD Change Limit1340271127.23318529.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.68523251.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.