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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
nonoperational166377(None) 
conspirational1853963conspirational
nonoperating1555413nonoperati_n_g
nonrational11109123non___rational
operational1347523___operational
preoperational1853243preoperational
congregational1863434congregational
conservational1955344con_servational
conversational1954164con_versational
cooperation15410024co_operation__
cooperations1659194co_operation_s
generational1354824gen__erational
inspirational1554414_inspirational
noncooperation1863704noncooperation__
noncooperations1963174noncooperation_s
nondirectional1763084nondirectional
noneducational1762524noneducational
nonemotional1453784non__emotional
nonnational11107834non___national
nonoccupational2171244nonoccupational
nonoperatic1565794nonoperati___c
nonoperative1756284nonoperati__ve
nonpersonal13114434non_per__sonal
nonsensational1463274nonsensational
nonvocational1853704non_vocational
annexational1953265_an_nexational
antirational1278495_an_tirational
aspirational1455005__aspirational
compensational2073525co_mpensational
computational1994575co_mputational
conceptional1856915con_ce_ptional
condensational1753655condensational
configurational2162205configurational
confirmational21153395confirmational
conformational21153715conformational
conjugational2353695con_jugational
connectional1646725con_ne_ctional
connotational1554155con_notational
consociational1853555consociational
conspiration1648385conspiration__
conspirations1747725conspiration_s
contractional1756065con__tractional
convectional1947045con_ve_ctional
conventional1757165con_ve_ntional
conversional1755145con_ver_sional
convocational2054475con_vocational
cooperating1648425co_operati_n_g
cooperationist1864225co_operationist
correlational15113675co_rrelational
denominational1752545denominational
hyperrational2153935__hyperrational
innovational1553835inno__vational
insertional1147465_in_ser_tional
interactional1557005_in_teractional
international1357675_in_ternational
narrational1145445__n_arrational
negational1147155__n__egational
nonbehavioral2171015non_behavioral
nonconventional20102595nonconventional
nonfictional1754855non__fictional
nonfunctional1853765non_functional
nonnationals1294895non___nationals
nonoptimal1453835nonop___ti_mal
nonpractical1854235non_p_racti_cal
nonseasonal1153525non_se_a_sonal
nonspatial1255625nonsp__ati__al
nonterminal1355315non_ter_mi_nal
nontraditional1562635nontraditional
notational1048125__no__tational
observational1853185_o_bservational
operation11314005___operation__
operationally1854645___operationally
operations12312955___operation_s
perorational1446395pero__rational
populational1654415__populational
proportional1655815_propor_tional
reoperation13410905_reoperation__
reoperations14410065_reoperation_s
supernational1555615__supernational
transpirational1773105transpirational

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 Filter178691950240.343520965.0
2DLD Change Limit95024807.25013106.8
3Display Results80800.0461739.1
 (SQL Overall)178691807.63923391.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.