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

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

251 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
compilation174931(None) 
compilations1848681compilations
combination17108802combination
commination171111642commination
compellation1855102compellation
completion1647302comp_letion
complication2048202complication
computation1748712computation
copulation141111952co_pulation
recompilation1955152recompilation
bombination1765013bombination
capitation14311363c_apitation
coagulation1447273coagulation
coaptation1448343coap_tation
cogitation13410083co_gitation
collation11313993co__llation
colligation1457443colligation
collimation1557573collimation
combinations1897923combinations
comminations18810483comminations
comminution17105013comminution
commutation1748003commutation
compaction1846753comp_action
companion1577683comp__anion
compellations1954813compellations
compensation18126503compensation
competition1755773competition
complain1448763comp_la_i_n
completions1746913comp_letions
complexation25144243complexation
complexion2343753comp_lexion
complications2147433complications
composition1746793composition
compulsion1644673compul_sion
compunction19115903compunction
compurgation19134183compurgation
computations1848123computations
conciliation1648233conciliation
conflation15412083co_nflation
congelation14410343congelation
consolation13410983consolation
conspiration1648383conspiration
cooperation15410023cooperation
copulations151111113co_pulations
corporation151210653corporation
correlation1358553correlation
crepitation1548393crepitation
cumulation1448173cum_ulation
cuspidation1643493cuspidation
depilation13312033_depilation
domination13712373dom_ination
epilation11312963__epilation
nomination12712103nom_ination
population14810023po_pulation
recompilations2054953recompilations
abomination1547484abom_ination
admiration1347734adm_iration
ambulation1447874_ambulation
amputation1447344_amputation
aspiration1249994_aspiration
atomization2249244atom_ization
bombinations1884594bombinations
bromination1547814brom_ination
calcination1548904calcination
calculation1548294calculation
cancelation1547774cancelation
cantillation1446694cantillation
capitations1549854c_apitations
capitulation1644594c_apitulation
captivation1846174captivation
castigation1447974castigation
cavitation1549134c_avitation
cementation1559704cementation
chelation1439964c__helation
ciliation111112494c___iliation
circulation1549394circulation
cisplatin1344714cisp_lati_n
citation10314364c___itation
coagulations1546514coagulations
coalition1148704co__alition
coaptations1547544coap_tations
coarctation1595074coarctation
codification20108074codification
coeducation1646234coeducation
coevolution1654224coevolution
cogitations1448904co_gitations
cognation12310754co__gnation
cognition1247014cogni__tion
cohabitation1953934cohabitation
coition9314314co__i__tion
collations12312854co__llations
colligations1556834colligations
collimations1656874collimations
collocation1547174collocation
colonisation14176764colonisation
colonization232010234colonization
coloration12913184co_loration
colorization231711194colorization
columniation1665424columni_ation
combinational1984084combinational
combinative2055134combinative
combustion1644564com_bustion
commendation1946514commendation
comminutions1894314comminutions
commiseration1964044commiseration
commission1645624commi_ssion
commotion1576984com__motion
communication21106214communication
communization28116684communization
commutations1847264commutations
compactions1946544comp_actions
companions1697264comp__anions
comparatist1756324comparatist
comparative20176214comparative
comparator1665804comparat_or
comparison1644354comp__arison
compassion1645984comp_assion
compatriot1655964comp__atriot
compensations19136184compensations
competitions1845534competitions
compiling1637764compil__ing
complains1549194comp_la_ins
complaint15410254comp_la_int
completing1748424comp_leting
completive1946234comp_letive
complexations26134014complexations
complexions2443624comp_lexions
complicating2145634complicating
complin13312074comp_l__i_n
compositions1846254compositions
compression1756564compression
compulsions1744594compul_sions
compunctions20145694compunctions
compurgations20123894compurgations
computational1994574computational
conation101420884co___nation
conciliations1747204conciliations
condition12411164condi__tion
condonation1448854condonation
confirmation1946184confirmation
confiscation1945534confiscation
conflations16411144co_nflations
confliction1845234confliction
confutation1668724confutation
congelations1549734congelations
conjugation2146624conjugation
conjuration2049514conjuration
connation11314264co__nnation
conniption1446274conni_ption
connotation1347984connotation
consignation15136314consignation
consolations1449744consolations
conspirations1747724conspirations
constipation1648564constipation
consultation1447474consultation
contemplation1985264contemp_lation
continuation1448194continuation
conurbation1547464conurbation
conviction1748184convi_ction
convocation1847884convocation
convolution1645124convolution
cooperations1659194cooperations
cooption1288344coop___tion
coordination1595584coordination
copatron1246754co_p__atron
copulating1549374co_pulating
copulative1747294co_pulative
coronation12412074co_ronation
corotation12410974co_rotation
corporations16129484corporations
correlations1447864correlations
corrugation1445994corrugation
coruscation1545694coruscation
cotillion1145284co_til_lion
covariation1646774covariation
crenelation1346854crenelation
crenulation1347574crenulation
crepitations1647474crepitations
crimination1549414crimination
culmination1557644culmination
cultivation16116414cultivation
cumulations1547434cum_ulations
cupellation1544144cupellation
cuspidations1743344cuspidations
cyclization2746414cyclization
depilations14310904_depilations
dilation92215464___dilation
domiciliation18102504domiciliation
dominations14611044dom_inations
emulation11312394_em_ulation
epilations12311714__epilations
expiation18710424_expi_ation
expiration19610714_expiration
foliation121110794fo_li_ation
fomentation1647714fomentation
formulation1646364formulation
fornication1645954fornication
fumigation1645624fum_igation
gemination131410654gem_ination
hominization2657994hominization
humiliation1675194hum_iliation
imitation11510854_im_itation
immolation1446104_immolation
impletion1345404_imp_letion
implication1747774_implication
imputation1447124_imputation
inspiration1348374inspiration
iodination1159984io_dination
ionization19411274io_nization
jubilation1946054_jubilation
lamination12311224lam_ination
limitation1249154lim_itation
lobulation1247234lo_bulation
modulation13147934mo_dulation
morulation12148904mo_rulation
motivation1548084mo_tivation
mutilation1249754_mutilation
nodulation11127994no_dulation
nominations13410534nom_inations
oblation1039864_o__blation
obligation1346784_obligation
obviation1446094_obvi_ation
operation11314004_o_peration
oppilating1544854_oppilating
ordination1149414_ordination
oscillation1345494_oscillation
osculation1249674_osculation
ovulation1238984_o_vulation
oxidation1746324_o_xidation
palpitation1546244palpitation
pixilation1945914_pixilation
pollination1348014pollination
populations15148714po_pulations
postulation13119134postulation
recombination19106174recombination
recomputation1974394recomputation
respiration13511194respiration
romanization2389894romanization
rumination12410834rum_ination
sibilation12128774_sibilation
simulation1269584sim_ulation
slumpflation19101334slumpflation
solation8916154so___lation
solmization2247324solmization
sonication12411184so_nication
stipulation1356334stipulation
supination1249884_supination
suspiration1346544suspiration
temptation1446384temp_tation
trepidation1445494trepidation
ventilation1448164ventilation

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488192519.12616307.1
3Display Results2512510.1401792.9
 (SQL Overall)1786912519.68918442.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.