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 “disembarkationsa” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

148 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
disembarkations2461501disembarkations_
disembarkation2361572disembarkation__
debarkations1943654d__e_barkations_
embarkations2062254___embarkations_
debarkation1844245d__e_barkation__
demarcations1746125d__em_arcations_
disambiguations2162155disambiguations_
disembarking2252685disembark__i_n_g
embarkation1972585___embarkation__
declarations1546806d__eclar_ations_
demarcation1647026d__em_arcation__
desecrations1559216dese__cr_ations_
disambiguation2062226disambiguation__
disclamations1853726dis_cla_mations_
discolorations17104306discolor_ations_
disembarks1953126disembark_____s_
disembarrass1761426disembarra____ss
disembarrasses1981136disembarra_sses_
disembarrassing2171006disembarrassin_g
disinformations2173306disinformations_
disseminations1755086dissem__inations_
dissertations1465896dis__sertations_
fimbriations1943346fi__mb_riations_
impartations16135436_i__mpartations_
inebriations1456326_ine_b_riations_
misevaluations19133456mise_valuations_
separations1369276__se_par_ations_
adumbrations1752297_adumb_r_ations_
asseverations1652597asse_ver_ations_
celebrations1645747cele_b_r_ations_
cerebrations1646967cere_b_r_ations_
darnations1138417d_____arnations_
deaerations12311677d__e__aerations_
dealations11311377d__e__a_lations_
decantations1547947d__e_cantations_
decelerations1646427dece_ler_ations_
decerebrations1993747decerebr_ations_
declamations1745307d__ecla_mations_
declaration1447837d__eclar_ation__
decorations14312887d__e_cor_ations_
defalcations1845197d__e_falcations_
defamations1745897d__e_fa_mations_
defeminizations3053587defeminizations_
deflagrations1883027d__eflagrations_
deflorations1646067d__eflor_ations_
deformations1846847d__e_formations_
degenerations1546357dege_ner_ations_
deglaciations1753917d__eglaciations_
degradations1544557d__egra_dations_
dehydrations2043407d__ehydr_ations_
deliberations1645537d_eliber_ations_
demarcating1745207d__em_arcati_n_g
demodulations1754147d__emodulations_
demonizations25410247d__emonizations_
denervations1657097d__e_nervations_
denigrations1447357d__enigr_ations_
deportations1548467d__e_portations_
depravations1885377d__epra_vations_
dermabrasions186847d_ermabr_asions_
desecration14410077dese__cr_ation__
desegregations1763567dese_gregations_
desertions1139887dese___r__tions_
desiderations1545677des_ider_ations_
desperations1559527d__esper_ations_
desquamations2581757des_qua_mations_
deteriorations15164697deterior_ations_
deuterations1348087d__euter_ations_
devaluations1646357d__e_valuations_
devastations1645827d__e_vastations_
dieselizations2455917di_eselizations_
dilatations1246417di___la_tations_
dimerizations2548547di__merizations_
disaffiliations2263017disaffiliations_
disaggregations1962517disaggregations_
disambiguating2171897disambiguati_n_g
disapprobations2262657disapprobations_
disassociations1863167disassociations_
disclamation1754247dis_cla_mation__
discoloration16124727discolor_ation__
disconsolations1863207disconsolations_
discretions1447227dis___cr_etions_
discriminations2074607discriminations_
disembark1853437disembark_______
disembarked2152557disembark_____ed
disembarrassed2071127disembarra__ssed
disinclinations1863587disinclinations_
disinfestations1993507disinfestations_
disinflations1756297dis__inflations_
disinformation2063337disinformation__
disintegrations17153637disintegrations_
dislocations15136987dis___locations_
disorientations1683627disorientations_
dispensations1655487dis__pensations_
disputations15106177dis___putations_
disrelations1348507dis___relations_
disruptions14125687dis____ruptions_
dissemination1655797dissem__ination__
dissertation1366097dis__sertation__
dissertational1562577dis__sertational
dissimilations1755867dis_similations_
dissimulations1754907dis_simulations_
dissipations1546537dis___sipations_
dissociations1656017dis__sociations_
distillations1446947dis__tillations_
distortions1246617dis__tor__tions_
distractions1548757dis___tractions_
divagations16103837di___va_gations_
divarications1955507di___varications_
emaciations1548167___em_aciations_
emanations1289597___em_a_nations_
embrocations1843987___embrocations_
emigrations14187157___emigr_ations_
fimbriation1843557fi__mb_riation__
hibernations1744057hi___bernations_
imbrications1845687_i__mbrications_
immigrations1743727_i_mmigr_ations_
impartation15156107_i__mpartation__
importations16156147_i__mportations_
incarnations1446667_i__ncarnations_
inebriation1357247_ine_b_riation__
inseminations1546247insem__inations_
isomerizations2555157_isomerizations_
itemizations2347847_item__izations_
iterations10413827_ite___r_ations_
liberations1358947li___ber_ations_
librations12149067li___b_r_ations_
linearizations2355927line__arizations_
literations11610587lite___r_ations_
miscreations1647067mis___creations_
miseducations18113297mise__ducations_
misestimations18144427mise_stimations_
misevaluation18153627mise_valuation__
misinformations2282587misinformations_
observations1785017obse___rvations_
preparations1648317_pre_par_ations_
remigrations15227797__remigr_ations_
reparations13611667__re_par_ations_
reservations1588587rese___rvations_
retardations1396517__re_tardations_
reverberations19113587reverber_ations_
separation12510437__se_par_ation__
separationist1555277__se_par_ationist
seriations10316687__se___riations_
serrations10313097__se___rrations_
starvations1445057__s__tarvations_
subornations1446147__s_ubornations_
summarizations2754857__summarizations_
vibrations15157377vi___b_r_ations_

Search took 9 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 Filter178691950240.376475242.0
2DLD Change Limit950241488.22011560.1
3Display Results1481480.1231203.3
 (SQL Overall)1786911488.71920494.4
 
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.