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

140 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
translocation155468(None) 
translocations1664231translocations
translation1149482transl__ation
translocating1654282translocating
transaction1346303trans_ac_tion
transduction1584453transduc_tion
transection1357373trans_ec_tion
transfection1765393transfec_tion
transformation1963073transformation
translations1258373transl__ations
translocate1355533translocat__e
translocated1554423translocat_ed
translocates1455393translocat_es
transmutation1554403transmutation
transpiration1555423transpiration
transportation1663293transportation
transposition1554183transposition
transudation1355323trans_udation
allocation1248574__a_llocation
dislocation14147504__dislocation
granulation1246554granul__ation
mislocation15126414__mislocation
reallocation1454494_reallocation
relocation12312114_r__elocation
retranslation1354684retransl__ation
transactions1445884trans_ac_tions
transamination16103794transamination
transcription1764074transcription
transductions1664294transduc_tions
transections1446764trans_ec_tions
transfections1854854transfec_tions
transformations2062824transformations
transition1049704trans___ition
translating1249444transl__ating
translational1354744transl__ational
translative1456704transl__ative
translator1047224transl__at_or
transliteration1562124transliteration
transmigration17133384transmigration
transmutations1653804transmutations
transpirations1654724transpirations
transplantation1771874transplantation
transportations1762904transportations
transpositions1663674transpositions
transudations1454834trans_udations
transvaluation1763364transvaluation
triplication1695384tr_iplication
truncation1245454trun___cation
advocation1645745__a_dvocation
allocations1347775__a_llocations
allocution1244085__a_llocution
analyzation2354385__analyzation
annotation1047755__an_notation
application1747475__application
association1346155__a_ssociation
avocation14168995__a__vocation
bilocation1446125___bilocation
canalization23411165_canalization
collocation1547175__collocation
conglobation1754255_conglobation
consociation1648195_cons_ociation
consolation13410985_cons_olation
convocation1847885_con_vocation
cotransduction1962025cotransduc_tion
crenelation1346855crenel__ation
crenellation1453915crenel_lation
crenulation1347575crenul__ation
dislocations15136985__dislocations
echolocation1952815_echolocation
eradication14410115era__dication
fractionation1853205fractionation
granulations1345785granul__ations
granulocytic2061665granulocyti_c
gratification1946685gratification
gratulation1245995gratul__ation
haruspication2051605haruspication
insolation10410215__ins_olation
invocation1547545__in_vocation
location102113915_____location
mastication15610295_ma_stication
misallocation1753365misallocation
mislocations16145655__mislocations
mistranslation16123175mistransl__ation
provocation1847355pr__ovocation
ramification1998215_ramification
ratification17810665_ratification
reallocations1553805_reallocations
reapplication1954725reapplication
relocations13311145_r__elocations
renovation1358785_ren__ovation
replication15712015_r_eplication
restoration11412095_r_estoration
retranslations1454215retransl__ations
revocation15410815_r__evocation
rustication1349225_r_ustication
strangulation1464045stran_gulation
stratification1954675stratification
suballocation1761625suballocation
tabulation1247815t_abul__ation
tarnation9310095tarn____ation
trabeation1245885tra___beation
traction10412685tra____c_tion
trajection1944695tra__jec_tion
transacting1446525trans_ac_ting
transactional1553425trans_ac_tional
transactor1265175trans_ac_t_or
transaminations17113425transaminations
transcriptions1863635transcriptions
transductional1782515transduc_tional
transecting1447375trans_ec_ting
transfecting1855165transfec_ting
transfiguration1962225transfiguration
transfixion2154205trans__fixion
transformative2261925transformative
transfusion1454235trans__fusion
transgression1462695transgression
transitions1148925trans___itions
translate9412275transl__at__e
translated1149295transl__at_ed
translates10411705transl__at_es
translators1156445transl__ators
translatory1454805transl__atory
transmigrations18132965transmigrations
transmission1454595trans_mission
transmountain1561845transmountain
transmutative1863035transmutative
transnational1353915trans__national
transoceanic1662765trans_oceani_c
transpirational1773105transpirational
transpontine1465135transpo_ntine
transporting1555785transpo_rting
transpositional17112335transpositional
transposon1254475transpo___son
transvaluations1863025transvaluations
triangulation1452705trian_gulation
tribulation1346495tribul__ation
trifurcation1753275tr_ifurcation
triplications1795075tr_iplications
trisection1245985tr_is_ec_tion
truncations1344765trun___cations

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 Limit1247901408.39014873.7
3Display Results1401400.1101272.7
 (SQL Overall)1786911408.89020100.2
 
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.