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

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

96 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
biotechnologies238126(None) 
biotechnologist2371562biotechnologist
biotechnology2461363biotechnolog__y
technologies1845973___technologies
ichnologies1746364_i___chnologies
technologizes2853424___technologizes
autecologies1554575_autec__ologies
bacteriologies1952825bacte_riologies
conchologies2054565_co_nch_ologies
dialectologies1892085dialec_tologies
ethnologies1547985____ethnologies
iconologies1447095_i___conologies
lichenologies1952915li___chenologies
lithologies1546835li_t__h_ologies
oceanologies1554235__oce_anologies
oecologies1339465__o_ec__ologies
oenologies1139395__o_e__nologies
poenologies1448325_po_e__nologies
soteriologies1453875_sote_riologies
technologic1954485___technologi_c
technologist18137405___technologist
technologists19125705___technologists
technologize2753445___technologize
technologized2962625___technologized
volcanologies1952345_vo_lcanologies
anthologies151012016_ant__h_ologies
archeologies1845006___archeologies
balneologies1553316balne___ologies
bibliologies1753376bi___bliologies
biologies12311186bi______ologies
codicologies1853666_codic__ologies
cytotechnology2871026cytotechnolog__y
demonologies1645506___demonologies
ecologies12312356____ec__ologies
electrologies1656266__electrologies
enologies10312986____e__nologies
epistemologies1962036episte__mologies
ethologies14310546____eth_ologies
geochronologies2261996geochronologies
gynaecologies2052166gynaec__ologies
gynecologies1953446_gynec__ologies
hierologies1547066hi__e__rologies
histologies1546636hist____ologies
ichthyologies2552296_i_chthyologies
ideologies1237336_i_de___ologies
immunologies1774306_i__mmunologies
kinesiologies1851836ki_ne_siologies
limnologies1445536li____mnologies
liturgiologies1661216li_turgiologies
menologies13310606___me__nologies
meteorologies1653586_mete_orologies
monologies13312546_mo____nologies
morphologies2044526_mo_rph_ologies
myrmecologies2352436myrmec__ologies
mythologies2047846_myt__h_ologies
nanotechnology237986nanotechnolog__y
necrologies1447986___nec_rologies
nephologies1747356___neph_ologies
nephrologies1845076___nephrologies
oinologies1148306__o___inologies
oncologies1348656__o_nc__ologies
ophiologies1746016__o__phiologies
organologies1454086__o_rganologies
osteologies1247056_oste___ologies
otologies10311406__ot____ologies
pathologies1748736_pat__h_ologies
penologies13311236___pe__nologies
phenologies1749356__phe__nologies
phonologies17410006pho____nologies
photobiologies2265156phot_obiologies
photogeologies2163896phot_ogeologies
phrenologies1846316_phre__nologies
proctologies1746316pro__c_tologies
protozoologies2663166prot_ozoologies
psephologies2044846__pseph_ologies
psychologies23127856__psych_ologies
pteridologies1762936__pteridologies
radioecologies1882706radio_ec__ologies
selenologies1345286___selenologies
sinologies1148896si_____nologies
sitologies1148706si_t____ologies
sociologies1447806_so__c_iologies
stereologies1345916__ste_reologies
synecologies1844166_synec__ologies
technological2155146___technological
technology1944916___technolog__y
teleologies1247516___te_leologies
teratologies1346876___teratologies
terminologies1653446___terminologies
theologies141010106___t__heologies
tocologies1349766___toc__ologies
toxicologies2263756_toxic__ologies
trichologies1845576__trich_ologies
venologies1438376___ve__nologies
victimologies2151766vict__imologies
vulcanologies1951996__vulcanologies

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.360496363.9
2DLD Change Limit95024966.92013731.8
3Display Results96960.0631523.8
 (SQL Overall)178691967.34324334.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.