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

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

73 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
chirrup1412383(None) 
chirrups15133041chirrups
chirrupy18132021chirrupy
chirp124717162chi_r_p
chirr105015902chirr__
chirre114111852chirr_e
chirred133612122chirred
chirren12388742chirren
chirres123812252chirres
chirrs114514982chirr_s
chirruped1742162chirruped
chiru105317152chi_ru_
chirus114615692chi_rus
cirrus8349172c_irrus
stirrup943002stirrup
charqui2144003charqui
charr104821783charr__
charred134614483charred
charro114212953charr_o
charros124312143charros
charrs115219193charr_s
charry145012113charr_y
checkup2043323checkup
cherry144810763cherr_y
cherub1337263ch_erub
chetrum1445343chetrum
chiaus113611313chi_aus
chibouk1843923chibouk
chillum1435443chillum
chimp145216473chi__mp
chip116726423chi___p
chiral114614413chi_ral
chirk144516183chi_r_k
chirked173810333chirked
chirker16429323chirker
chirks155414843chi_rks
chirm125317063chi_r_m
chirmed15379733chirmed
chirms135113983chi_rms
chiro105320343chi_r_o
chiros114617773chi_ros
chirped15379783chirped
chirper14359963chirper
chirps135414003chi_rps
chirpy16498913chi_rpy
chirring142610173chirring
chirruping1842053chirruping
chorus115014773ch_orus
churr104512853churr__
churred13409173churred
churro11448353churr_o
churros12427583churros
churrs115111513churr_s
circus104310593c_ircus
cirque1735853c_irque
cirri7710723c_irr_i
cirrous93111063c_irrous
citrus83610923c_itrus
corrupt1149103c_orrupt
coverup1434623coverup
croup95616783c__roup
hiccup1554393_hiccup
irrupt846993__irrupt
larrup835713_larrup
shirr84716923shirr__
shirred113710503shirred
shirrs94413173shirr_s
sirup74014913_si_rup
stirrups1042603stirrups
whirr114611193whirr__
whirred14386933whirred
whirrs12408593whirr_s
whirry15477063whirr_y

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit134027735.79623124.1
3Display Results73730.0302433.3
 (SQL Overall)178691736.24928595.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.