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

74 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
fractionators186213(None) 
fractionator1762341fractionator_
fractionates1754162fractionat_es
fractionations1952862fractionations
fractionate1654263fractionat__e
fractionated1853083fractionat_ed
fractionating1953083fractionating
fractionation1853203fractionation
activators1545944__acti_vators
brachiators1853524brachi__ators
deactivators1852574deacti_vators
fascinators1644704f_asci_nators
fractional1547134fractiona___l
fractionalize27115204fractionalize
fractionalizes28134774fractionalizes
fractionally2055294fractiona_lly
fractions1449104fraction____s
machinators1854404_machi_nators
ratiocinators1562154_ra_tiocinators
vaccinators1854144_vacci_nators
actioners1147725__action__ers
activator1446445__acti_vator_
actuators1146445__act__uators
alienators1045785__a_lienators
alternators1154105__alternators
brachiator1753545brachi__ator_
buccinators1752775_bucci_nators
captivators1853625_capti_vators
castigators1445545_casti_gators
deactivator1752845deacti_vator_
detonators1145855__det_onators
eradicators1445285era_di_cators
fabricators1854075f_abri_cators
facilitators1752785f_acilitators
factional1478765f_actiona___l
factionalism1987085f_actionalism
factionalisms20106365f_actionalisms
factionally1946395f_actiona_lly
factions133013065f_action____s
fascinator1545215f_asci_nator_
fictioneers1652685f_iction_eers
fraction1359485fraction_____
fractionalized29144115fractionalized
fractioned1644615fraction___ed
fractioning1744335fraction__ing
fractious1456145fracti____ous
fractiousness1856875fractiousness
frictional1546255frictiona___l
frictionally2054925frictiona_lly
frictionless1752555friction_less
frictions1448035friction____s
functionaries1863015functionaries
functionary1953755functiona__ry
lacrimators1553915_lacri_mators
laminators1247055_la_mi_nators
machinator1744585_machi_nator_
masticators1546325_masti_cators
originators1253925or_igi_nators
pronators11411305pr____onators
radiators1049325_ra_di__ators
ratiocinator1472315_ra_tiocinator_
rationales1049315_ra_tiona_les
rationals949945_ra_tiona__ls
reactionaries1553545reactionaries
reactionary1653695reactiona__ry
resonators1045815_r__esonators
ruminators1286065_r_umi_nators
rusticators1344945_rusti_cators
tractional1248055tractiona___l
tractions11511625traction____s
urinators947635ur___i_nators
vaccinator1744545_vacci_nator_
vacillators1653335_vac_illators
vaticinators1763385_va_ticinators

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.406440125.6
2DLD Change Limit124790748.36014927.0
3Display Results74740.0461608.7
 (SQL Overall)178691748.81220278.1
 
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.