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

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

132 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
teleportation155212(None) 
teleportations1651821teleportations
deportation1449303__deportation
exportation2047443_e_xportation
reexportation2253143reexportation
reimportation17114033reimportation
celebration1546464cele_br_ation
delectation1448554dele__ctation
deportations1548464__deportations
elaboration1345744_elabor_ation
evaporation1645554_evapor_ation
exhortation2145024_e_xhortation
exportations2146654_e_xportations
importation15147124__importation
melioration1368184mel_ior_ation
redecoration1546014redecor_ation
reexportations2352844reexportations
reimportations18113594reimportations
teleporting1453274telepor__ting
temporization2675994te_mporization
temptation1446384te_mp__tation
toleration1048964tole__r_ation
transportation1663294transportation
acceptation1765325accep__tation
allegorization24103115allegorization
amelioration1464005amel_ior_ation
celebrations1645745cele_br_ations
cementation1559705ceme__ntation
cerebration1547925cere_br_ation
coloration12913185col__or_ation
corporation151210655_corpor_ation
crepitation1548395_crep_itation
deaeration11313015deae__r_ation
decapitation1748685decap_itation
deceleration1547175deceler_ation
decoration13314425__decor_ation
decrepitation1884805decrep_itation
defloration1547265de_flor_ation
deformation1747665__deformation
degeneration1447285degener_ation
delectations1547455dele__ctations
delegation1238885dele___gation
deliberation1546365deliber_ation
delimitation1597265del_imitation
denervation1567945dene__rvation
denotation11311085__deno_tation
deputation1339395__dep_utation
desecration14410075dese_cr_ation
desperation14510115de_sper_ation
despoliation1546715de_spoliation
deterioration14145285deterior_ation
detestation1248365dete__station
elaborations1444925_elabor_ations
elevation1239235_ele___vation
elicitation1347535_el_icitation
elongation1145355_el__ongation
elutriation1146715_el_utriation
enervation1369475_ene__rvation
evaporations1744695_evapor_ations
excoriation2048435_e_xcoriation
execration1949835_exe_cr_ation
exercitation2155385_exercitation
exhortations2244455_e_xhortations
expectation2266485_e_xpectation
expiration19610715_e_xpir_ation
exploitation2154705_exploitation
exploration2066715_explor_ation
expurgation2154555_e_xpurgation
federation1449575fede__r_ation
felicitation1745105fel_icitation
fenestration1596075fenestr_ation
flirtation1354825_fl__irtation
floatation1344685_fl__oatation
floriation1367795_fl__oriation
flotation1267815_fl__o_tation
generation11312425gene__r_ation
hebetation1557095hebe___tation
impartation15156105__impartation
importations16156145__importations
levitation1349445__le_vitation
malformation1953325mal_formation
meliorations1466755mel_ior_ations
molestation1365965mole__station
necessitation15123095necessitation
nonimportation1862225nonimportation
palpitation1546245pal_p_itation
peltation11312965pel____tation
penetration1349895pene_tr_ation
perforation1649005pe_rfor_ation
peroration12316005__peror_ation
perpetration1647135perpetr_ation
perspiration1656835perspir_ation
potation101716785____po_tation
preformation1946475_preformation
preparation1549275_prepar_ation
preportion1448875_prepor__tion
reapportion1554035reappor__tion
reciprocation19183495reciprocation
recordation1449265__recordation
recuperation1656725recuper_ation
redecorations1645085redecor_ations
reformation1648415__reformation
regeneration1348195regener_ation
relegation11610025rele___gation
relocation12312115rel__o_cation
reluctation1347965rel__uctation
renegotiation14113665renegotiation
reoperation13410905re_oper_ation
reparation12612725__repar_ation
repartition1344975__repartition
reprobation1548505__reprobation
reputation12411885__rep_utation
reservation1489145rese__rvation
respiration13511195re_spir_ation
restoration11412095re_stor_ation
revegetation16105305reve_getation
separation12510435__separ_ation
sexploitation2252955sexploitation
teleport1048645telepor__t___
teleported1343315telepor__t_ed
teleports1145455telepor__t__s
temporizations2785755te_mporizations
temptations1545415te_mp__tations
terrorization2256665te_rrorization
theorization2456765t_he_orization
tolerations1158135tole__r_ations
transportations1762905transportations
trepanation1345485t_rep_anation
trephination1754035t_rephination
trepidation1445495t_rep_idation
vegetation1448215vege___tation
veneration13412345vene__r_ation

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901328.01615567.6
3Display Results1321320.0931419.4
 (SQL Overall)1786911328.49921024.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.