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

83 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
rectrix164536(None) 
tectrix1644261tectrix
directrix1952422directrix
recti73619622rect_i_
retrim83514882re_trim
bestrid1039973bestrid
bisectrix2051853bisectrix
centric11312403centric
cicatrix1942793cicatrix
dextrin1587543dextrin
editrix1543643editrix
electric1249183electric
estrin6315923_estrin
executrix1751473executrix
hectic132311523hect_ic
heretrix1845133heretrix
heritrix1843893heritrix
lectin82515013lect_in
matrix1539843_matrix
metric10314673me_tric
oestrin7312243oestrin
oratrix1444533oratrix
orectic1138823orect_ic
pectic122913873pect_ic
pectin102615533pect_in
pretrim11310783pre_trim
reaffix2042323reaffix
recarry1245063recarry
recit75235103rec__it
reclaim1137753reclaim
recoil84016723rec_oil
recoin84320293rec_oin
record96117433recor_d
records105213923records
recork126315493recor_k
recorks134813023recorks
recruit939773recruit
recta74220263rect__a
rectal84418133rect_al
rectify1536453rectify
recto74520803rect__o
rector84019753rect_or
rectorial11119893rectorial
rectories11314643rectories
rectors93520523rectors
rectory123512733rectory
rectos85718783rect_os
rectrices1338873rectrices
rectum103411283rect_um
rectums11338523rectums
rectus83314633rect_us
recur74116843recur__
recurs83315803recur_s
recurve1237403recurve
redtail858713redtail
refix155212483re__fix
remix145916553re__mix
remorid10311863remorid
rerig64018483re__rig
restrain8311703restrain
restrict10313633restrict
restrike1239673restrike
restring91518783restring
restrive11310923restrive
retail65522073re_tail
retain64523283re_tain
retax124517973re_t_ax
retia55326113re_t_ia
retie55735303re_t_ie
retire64927013re_tire
retrain7615423re_train
retral64419743re_tral
retrial7615553re_trial
retried84419153re_tried
retries74129073re_tries
retrims93612373re_trims
retro55020953re_tr_o
retros63820193re_tros
retry84718083re_tr_y
reverie103615163reverie
tetri52716453te_tri_
tetris62816293te_tris
tortrix1444193tortrix

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.403443402.0
2DLD Change Limit134027836.31321230.3
3Display Results83830.0332515.2
 (SQL Overall)178691836.74926476.7
 
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.